In a mail template, can you refer to a value ...

workflow
(Alfredo Pou) #1

In a mail template, can you refer to a value from another table other than the workflow table? I need to include data that is in another table, I could add columns in the target data table, but it would be redundant information. Could something like that work? for example: << [table]. Field >>

(Philip Garrett) #2

@Alfredo_Pou

Yes you can display values from other tables.

If you have a Ref field in your original table, you can use that to display the field value from the referenced table. See topic “Dereference Expressions” in this article help.appsheet.com - Template Variables

If the records you want to display are in child records of the original table, you can use a Start expression and an embedded template to display values from the child table. See topic "Templates with Embedded Templates’ in this article https://help.appsheet.com/behavior/workflow-sending-email/email-change-event-templates

Template Variables help.appsheet.com

(Alfredo Pou) #3

Thank you very much!

(Philip Garrett) #4

@Alfredo_Pou

Yes you can display values from other tables.

If you have a Ref field in your original table, you can use that to display the field value from the referenced table. See topic “Dereference Expressions” in this article help.appsheet.com - Template Variables

If the records you want to display are in child records of the original table, you can use a Start expression and an embedded template to display values from the child table. See topic "Templates with Embedded Templates’ in this article https://help.appsheet.com/behavior/workflow-sending-email/email-change-event-templates

Template Variables help.appsheet.com

(Alfredo Pou) #5

Thank you very much!