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?
<<Start: FILTER("table 1", ...)>>
...
<<End>>
<<Start: FILTER("table 2", ...)>>
...
<<End>>
.
.
.
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)>>
<>
The three dots are parts you would need to fill in.
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.
User | Count |
---|---|
43 | |
27 | |
24 | |
23 | |
13 |