Are you using Save As Excel or Export Records to export the data to excel?
Save As Excel should reproduce the layout's order (I think).
WIth Export Records, you can specify any order you want. If you use a script to do this, you can make sure that the order is always the same each time you export without having to set it up each time.
No luck. I've tried exporting to Excel and CSV. I've even tried saving as "mer" and naming the file ".csv". Each time, it saves the field names in alphabetical order.
Any other ideas on how to save the data from the layout in a custom field order?
When you select Export Records, you eventually get the dialog shown in this image. The box circled in red controls the field/column order. After you have selected your fields, you can drag the little black arrows to the left of the field names up or down to change their position in the export order.
Yes - I've tried to specify the field order via this window, but it simpy exports all fields aphabetically regardless of the "Field export order" specifications.
Any other ideas?
I need no other ideas as what I have described does indeed work. I superimposed two windows to match a screen capture of the dialog box with the excel file it produced. Note that the left to right order of the columns matches the top to bottom order in the dialog.
And here is a second export with a different order specified for the same three fields/columns: