Oct 23, 202312:04 AM - edited Oct 23, 202310:44 AM
I have the following bases tables:
Teams has records of people grouped by single select types of teams (Management, Development, Operations).
Emails has email records that is populated by a form. The form asks for, among other things, the group it is to be sent to. This is a separate field not linked to the team field in Teams.
Once the email has been approved, i have a trigger when the status of the email submitted is "good to go".
I would like to know how to go about automating sending an email when that is done, to the defined group of people. e.g. Team "Management" is selected on the email submission form, once approved the an email sends to that group.
Appreciate any help 🙂
PS: Is there a way to manually send an email from airtable? Perhaps it can be modified to send when a different form is filled out, with say subject line, body, etc.