Send emails in batch

[Greg041]

Hello, I am new to AppSheet, and I've been watching some tutorials over the last few days. I have a client who needs to send an email to multiple users using different email templates from time to time. I was thinking of something like a multi-select for the users and another select box to choose the email template to send to these users, followed by an action button to execute the action. The thing is that none of the tutorials I have seen so far present such functionality in any way, so I would like to know if anyone has developed a system like this in AppSheet. I just want to know if it is possible so that I can immerse myself with more confidence in the documentation and develop it too.

[Suvrutt_Gurjar · Accepted solution]

I believe your thinking is on the right track. In general, I believe what you are looking for should be possible.

In the automation TO field,  you may need to have an enumlist column with base type as email that the user can use to select the desired emails that the user needs to send emails to.

Regarding different templates there can be another enum column called say [Email_Format] where the user can select the template that she/he needs to send to. All templates can have a triggering condition such as 

AND([_THISROW_BEFORE].[Email_Format]<>[_THISROW_AFTER].[Email_Format] , [_THISROW_AFTER].[Email_Format]= "Template 1")

The above condition can be used with "Template 1"  automation bot.

AND([_THISROW_BEFORE].[Email_Format]<>[_THISROW_AFTER].[Email_Format] , [_THISROW_AFTER].[Email_Format]= "Template 2")

The above condition can be used with "Template 2"  automation bot and so on.

You could even try a single bot with multiple branching steps depending on the template format selected condition.

Of course, the above are basics. You many need little experimentation and more elaborate configuration .