Email contacts from portal using radio button Boolean values to select records
Using: FileMaker Pro 12 Advanced
I am a Filemaker beginner/novice (no experience in scripting or calculations though I am willing to learn), and I have a database with related tables as below. The tables are related through a junction table Contacts_Projects; Contacts_Programs etc
There are portals in the tables Projects, Programs, Submissions and Jobs which show the Contacts related to each record therein.
Each portal has a radio button field with Boolean values (yes/no). This field is stored in the relevant junction table.
I want to be able to:
- Have this Boolean field available in each row of the portal
- Connect a ‘Send Email’ button to all contacts that have a ‘yes’ value selected in their row of the portal.
The email addresses are stored in the table “Contacts”. Each contact can potentially have two associated emails stored in the fields “Personal Email” and “Business Email”, and I’d like the email generated to be sent to both emails via my email client.
Any assistance in how to do this would be greatly appreciated.