Bots and Automated Emails

AppSheet AppSheet Q&A
,
1

Hello!

I am in a bit of a rut and am looking to the community for guidance/advice.

I am trying to implement an automated bot to send emails on different occasions to data changes (Deletes Only, Adds Only, and Updates). I’d like these emails sent to column results ([Email] for example), but only for the email listed in the specific row who has experienced the data change. Is there some sort of expression to limit these emails to target the column results of a specific row that is being updated, deleted, or added?

Right now I think it will just shoot an email to all results in the [Email] Column.

Thanks in advance!

2

Maybe I misunderstand, but, data change Bots run in the context of a single record, the one that got changed. If that record has an email address in the [Email] column, then just put [Email] in the “To:” field.

2 Likes
3

Jason_Stetler:

Right now I think it will just shoot an email to all results in the [Email] Column

It shouldn’t since [Email] is just one record, unless it’s an EnumList base Email.
TableName[Email] by the other hand could make a list of [Email] from all the rows.

2 Likes