2 Replies Latest reply on Jun 13, 2017 3:35 PM by philmodjunk

    How do I make a standardized, saved field order for exporting data?



      When I export my data, I would like to have the fields ordered and saved in a specific order so I can choose to export data in the same columns/order every time. Applying the layout and alphabetical order for field export isn't what I'm looking for. Rather, I'm hoping to find a way to save the field orders and better yet, be able to share this with my colleagues if that's possible. Has anyone been able to do this?

      Thanks in advance!


        • 1. Re: How do I make a standardized, saved field order for exporting data?



          Thank you for your post!


          It looks like you would want to Script the Export, so that you can specify the export order for everyone. You might see Export Records Script Step.


          I'm also going to move this thread from the FileMaker Community Feedback Space (which is specifically for input on the Community itself) to the Discussions Space where you should receive more views and potentially more feedback on this topic!



          FileMaker, Inc.

          1 of 1 people found this helpful
          • 2. Re: How do I make a standardized, saved field order for exporting data?

            Yes, script the import.


            Case in point:


            I was tasked with some data mining where some of the criteria specified wasn't entirely clear. So I performed a find, sorted the records, exported the fields into the desired file type and with a specific field order.


            I then created a script with a stored find (first time I've used stored criteria in years), sort order and an export fields script step. When you add these steps to a script, the criteria for the most recent find, sort and export are all there to be automatically added as parameters to these script steps.


            When, a week later, I got a message that said "that's not quite what I need, can you give me this data...." I was able to use the script to restore my settings for find, sort and export, before then modifying criteria as needed to give them what they needed. It would have added another hour to my work if I had not created that temporary script.

            1 of 1 people found this helpful