Workflow email body pulling data from multiple smartsheet tables?

[anonymous]

Hi team,

I have an app where users will fill out four forms. Each form has data from four different tables using smartsheet as a data source. I am trying to find a way to have users email themselves data from each of the four forms in the email body using workflow. From there the user would be able to print the email (all four forms).

That may sound confusing, but I’m trying to say is in the email body when using workflow, I want the email body to pull data from four different tables that all have a relation to one another using an ID number.

I can’t use the attachment template because Smartsheet doesn’t have file store.

With that said what is the best way to get data from different tables into the email body.

SELECT expression?

[Workflow - using multiple tables in a set of forms](https://community.appsheet.com/t/workflow-using-multiple-tables-in-a-set-of-forms/17541) Questions

See attached. Wondering if it’s possible to pull multiple table data into a google doc template? What I tried (in the attached) didn’t work. Workflow triggered but I didn’t get the data I wanted. [iap workflow]

[Steve]

<<Start: FILTER("table 1", ...)>>
...
<<End>>
<<Start: FILTER("table 2", ...)>>
...
<<End>>
.
.
.

[anonymous]

Sorry Steve, going to need a little better explanation to understand what that is saying.

The three dots after the comma in the parentheses, does that represent the fields from the table?

If it does, I’m getting a red error.

<<Start: FILTER(“Underground Release Form”, Jobsite Address)>>

<>

[Steve]

The three dots are parts you would need to fill in.

[anonymous]

I am still confused by that article.

Just to clarify, that Start expression can be used in the email HTML body?

I’m not referring to the “Email body template.”

I’m referring to the actual “Email Body” in the workflow.

Notice in the screenshot below how I have <<Overhead or Underground?>> in the third sentence?

That is a field value from one (target) table. I am trying to find a way to get a field value from another table.