Sending an email to all project members

I am using airtable as my data source and all users are listed in the users table. My softr app is a project management tool, and in many cases I may have multiple users assigned to a project. I am looking for a way to create a “button” to send an email to ALL project members.

Presently there is an email address field populated in the project summary, but that is only a single address, written as an actual email address. In the same details panel I have a field that displays all the project members as tags.

Is there a way soft can achieve this?

Now that I am actually writing this out as a question I am coming up with this possible solution: I am thinking that I should probably build a new field in air table, that would contains the aggregate email addresses. Such as “mailto: user1@email.com, user2@email.com, user3@email.com” all in single field, then have that field populate a new field in the softr app?

If anyone cares… I got this to work, pretty much the way I thought.

  1. Created a new field in airtable to rollup the email address field from all users in the project members field.
  2. Created a new field in airtable to add the “mailto” to the rolledup email address from the previous step
  3. 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.