Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Script to Sort by File Status

Campus Club

Recommended Posts

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'?

Link to comment
Share on other sites

Create a self join relationship using the Member Status Field

Name it Active Members



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.

Link to comment
Share on other sites


This topic is now archived and is closed to further replies.

  • Create New...

Important Information

Terms of Use