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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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