bepsis

how to: multi-request find from list of values

Discussion created by bepsis on Aug 9, 2018
Latest reply on Aug 9, 2018 by philmodjunk

Hi,

 

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,

Thanks

Outcomes