Jump to content
Sign in to follow this  
sunbird

Maintaining field order when exporting to Excel?

Recommended Posts

I am trying to export a series of fields to Excel in the same order in which they appear on my layout (which is, incidentally, also the order in which they appear in the define database window). However, Filemaker displays all fields alphabetically by name in the export dialog box.

I imagine that there has got to be an easier way to export a group of fields than picking through the alphabetized list and then pulling each out one by one, but I can't figure out how. Is there any way to get the export order to automatically match the existing field order?

Many thanks in advance.

Share this post


Link to post
Share on other sites

In the Export dialog, you can choose to show the field list from the entire table. Fields in that list, are in the last sort order of the Define Database Fields list.

In general, if the export needs to be repeated, you should use a script to restore the export order.

Share this post


Link to post
Share on other sites

What do you mean, 'in the last sort order of the Define Database Fields list'? In my Define Database window, the fields are all in the desired order, but once I get to the Export dialogue box they are all listed alphabetically. That's the problem - I have something like 300 fields and they are all listed alphabetically.

Does anyone know how to change the display so that the fields in the Export window are in the order in which they appear in the Define Database window? If so, I'd very much love to hear how. Thanks.

Share this post


Link to post
Share on other sites

Isn't there a drop-down menu above the list of available fields?

Share this post


Link to post
Share on other sites

Hey, thanks so much. I saw that but somehow thought it was just to select between tables, and ignored it after that. I appreciate it - that is so much better!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Who Viewed the Topic

    1 member has viewed this topic:
    3DSteve 
×

Important Information

By using this site, you agree to our Terms of Use.