If anyone cares… I got this to work, pretty much the way I thought.
- Created a new field in airtable to rollup the email address field from all users in the project members field.
- Created a new field in airtable to add the “mailto” to the rolledup email address from the previous step
- created an “open URL” button in softer which open the mailto: link from the previous step.
This worked great when setting the action button to open in a new tab.
Note:
This did NOT work when setting the action button to open the URL in a side modal, stating there was a gmail problem. I didn’t explore much further as the new tab method worked great.