I am not sure how to write a script to do what I need. I have a records in Filemaker 13. I need to have records exported in a csv file for each group in column D. I have hundreds of records. I have attached a photo of a few records.
Sort the records by the D column, create a Loop through the records and grab the first value. Open a second window and Find that value and perform the export. Close that window and then continue looping through the records until a new value is found, then on that conditional, you're back to opening the second widow, performing the find and exporting on that value.
If your table isn't too big, send it over and I can create the script for you if you'd like.
I attached the file below.
I've added a quick scrip tfor your review. I did set this to output to a Mac, so if you're on Windows, you'll need to adjust. Take a look and let me know if this works.
techt wrote: I've added a quick scrip tfor your review.
I've added a quick scrip tfor your review.
Let me suggest a somewhat simpler method.
And here's a further mod that uses SQL, and provides the option to write to a time stamped folder on the desktop.
Uses shell scripts and applescripts that require a Mac.
Retrieving data ...