Template expressions if sending to multiple emails

[mattlops]

Hi!

I recently had a question while I was building a bot and I couldn't find anything about it.

I currently have 2 worksheets in one application: ''Trigger'' and ''Customers''

The worksheet ''Trigger'' has only one column (besides the Key) of type DateTime and whenever it is updated it triggers a bot

This bot sends each record in the Customers table an email with a link to a form.

Thinking about having a more personal text in the body of the email, I would like each email to be forwarded with the customer's name in the middle of the text, but when I try to include a column like <<[Name]>> the value of the DateTime column of the ''Trigger'' table in all e-mails.

Is there a way to include a name for e-mail triggered using this trigger format?

[booyah]

Take a gander at this.

https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/In-a-mail-template-can-you-refer-to-a-value/m-p...

[mattlops]

Thanks for the reply but in my case Dereference is not working

The ''Trigger'' table does not refer to the ''Customer'' table. What happens is that my bot's event is triggered through changes in the ''Trigger'' table but the Task is in the ''Customer'' table.

I wish there was a way to identify who the email is being sent to and put the person's name in the text according to their registration