I have a filemaker database with 1400+ participants. Often, we will want to export data on a particular sub-set of participants. Currently, we do this by entering find mode on a list view, creating X number of request lines and manually pasting in each participant ID we are interested in on each line. This is time consuming if we want to export data on a specific 200 participants.
Is there a way to script a find so that either a) filemaker reads from a .txt file on the desktop which is filled with desired participant ID's or b) opens a dialogue for the user to paste in a list of desired participant ID's, then loops through the entered list, automating the creation of a new request line and entering the participant ID in the appropriate field?
Any help is greatly appreciated,