Exporting a list of one field based on value of another field
I need to export a list of email addresses from a Contacts table, but only if the record contains a 1 in the 'Subscribed' field.
Exporting as a text file, with each email address on a separate line, would be sufficient.
I'm familiar with doing this in SQL, but not in Filemaker.
Can anyone provide an example, or point me to a tutorial? Thanks.
The following can be done manually or in a script:
Go to a layout based on this table of email addresses
Enter Find mode
Specify 1 in the Subscribed field
Perform the find
Use export records to export your found set, specifying the email address field as the only field to be exported