I have a table of 100 members of our makerspace. There's a ROLE field that is multiselect that has Lead, Board Member, Officer, etc. 9 of the members of the "Member" table have "Board Member" and I have a subsequent view called "Board Members" that filters to show all board members (and that have an active status).
I want to have an automation on another table (Applications) that would send a gmail to each of the 9 members in the "Board Members" view/grid. Does anyone have an example of this? FWIW, I want to include a url of a fillout form including the RECORD_ID() of the application record as well as a parameter of the email address to pre-fill the board members identifying information so when they approve/comment on the form we can identify the source board member.
Thanks in advance
Jeff
PS: I know that on the free plan there are limits on sendmail to non-airtable emails, but that gmail might work instead.