Customize email body with automation

[ToufikAG]

Hello,

Is it possible to customize the email body while using AppSheet automation ?

I want to insert the USERNAME() and other data from the sheets.

Please see picture below :

[dbaum · Accepted solution]

Yes, it's possible. References to app data need to be expressed from the context of the table the automation task is associated to per the task's Table name property. Within the angle brackets in the template to indicate a variable, you would also need to enclose the reference to a column value within brackets just like any other expression within AppSheet. Within a variable, you can also use AppSheet functions, such as USERNAME(); however, with regard to that particular function, note that it doesn't actually work for many authentication providers.

So, if you have a [User Name]column in the table that the automation task is associated to, you could use something like the following:

<<[User Name]>> 

[ToufikAG]

Issue solved ! Thank you.😊