Changing Order of Columns

Hi @danielpw,

Yes you can actually drag and drop your favorite order for the columns, on the settings page, per form.

(Don’t forget to press “save” after you’re done.)

Hey @doekenorg,

That’s great to hear. Thanks for getting back to me so quickly!

Thanks,
Dan

Hey @doekenorg,

I didn’t want to open a new thread since I still have a question about ordering columns.

I am using the ‘gf_excel_field_separated_name’ filter to separate the Name field into separate columns for First Name and Last Name.

What I am needing now is to order the separated columns so that the Last Name column comes before the First Name column in the exported spreadsheet. The drag and drop functionality included with the plugin doesn’t let you order the separated Name fields (First and Last).

Is there a way to implement code that will order the Last Name field/column before the First Name field/column without having to rename each column and copy over the values of the First Name field to the Last Name field and vice versa?

Hi @danielpw,

I’m actually looking into this, making all columns sortable. But it’s only an idea at the moment. And I thought I had more than enough hooks to help you out, but it seems I need to add even more ?? I’ve added a feature to the roadmap to make sorting by code possible, and maybe we can go from there.

As a sort of fix… If you only have the 2 fields, you can flip them with this code:

add_filter('gfexcel_field_name_fields', function ($fields, $entry) {
    return [$fields[1], $fields[0]];
}, 10, 2);

But this only flips the values. So lastname will have the first, and vice versa.

The only solution there is to use gfexcel_field_label to change the first name in to the last name, and the other way around.

I hope that’s OK for now. Ill make something prettier for the next release.