Email Template Data from Tables

fenapp · 10-04-2020 05:02 AM

I have an app with three tables
A workflow on my Customer Table allows me to send an email and I can create an email template with data from my Customer Table and also data from my Related survey Table.
how can I add Data from my unrelated User Table to the email Template?

I need this to produce a Header for each User on the email template?

As I am new to Appsheet, please make the instructions as simple as possible
Many thanks
Andy Wells

Steve

What have you tried?

fenapp

I have set up a workflow to send my email.
When i go to the template for the body of the email I click “Create”
The Template has the “customer” details and I can embed a table with the “Related Surveys”.
However whatever I put above the customer details fails to work.
I have attached a screengrab of the body of the email.

Thanks
andy

Steve

Presumably, [USER] is somehow related to the customer described by the email? Is there any information in the customer row that might be used to identify which row in the user table should be used? Or perhaps teh customer row even includes a column of type Ref to the users table?

fenapp

No the user table is seperate and not related to the customer table.

The customer table does have the useremail though (and this is also in the user table.

Steve

fenapp

Thanks Steve.
I used;

Lookup([Name],“USER”,“Name”,“Name”)

Works a treat.

Thanks
andy