I have a read-only view to a read-only table with a list of contacts. I want to be able to select multiple rows and send them an email (I want to be able to edit the email before sending it to them). I can’t seem to select multiple rows unless I enable editing on the table. Is there a way to work around it?
Hi @winhui
If you wish to select some rows for an email, then it means you have to change a data in order to track which rows you need for your email. It could be a simple column “YesNo_Selection”.
I suggest you set an action in order to set such column value to Yes or No.
2 Likes
Or you could create a temporary table with an ENUMLIST column to let the user choose email addresses from your contact table and create an external:start an email action.
In the To section use an expression based on the one described here (https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/Email-Action-to-Send-to-List-of-Emails/m-p/350197))
The action opens up a gMail message editor with to, subject and body prepopulated.
I suppose you can use a bot also if that is your preferred method.
2 Likes