Script to Sort by File Status

[Campus Club]

I work for a membership club that needs to rapidly sort members by active/inactive and export that list so that we can contact active members via email. We have a script that currently omits all members with no email address and exports them, but I need to add a component for active/inactive.

 

I am very new to FMP7, but I am familiar with programming in general, so I should be able to do this. There are simply a lot of commands to go through. How can I produce a list of only records with the "member status" field set as 'Active'?

[Robert Schaub]

Create a self join relationship using the Member Status Field

Name it Active Members

 

I.E.

Members :: Members

 

A script to get active members

 

Go to related records [Active Members] [show Related Record Only]

 

There now you have all your active members continue from here.