Trying to implement an email workflow. When I have template definition of:
<<Start:[Related Gen_Contracts]>>
<<[vLabel]>>
<< SELECT(Gen_Contract_TermDefinitions[ID], [Gen_Contract]=[_thisrow].[ID])>>Some string value
<>
I get an email that shows:
Occeas(Master Bed)-Grantland Dr Weekly Rental Agreement
Some string value
When I modify template to be:
<<Start:[Related Gen_Contracts]>>
<<[vLabel]>>
<< START: SELECT(Gen_Contract_TermDefinitions[ID], [Gen_Contract]=[_thisrow].[ID])>>Some string value
<>
<>
The result is this error message:
Failed: Action not performed because 2 errors are present. Error: Workflow rule โgenerateLeaseAgreementPDFtoEmailโ action โEmail New Lease Agreement as PDFโ Body template. Expression โStart:[Related Gen_Contracts]โ is invalid due to: Unable to find table โSTART:โ, did you mean โUnitsโ?. Error: Workflow rule โgenerateLeaseAgreementPDFtoEmailโ action โEmail New Lease Agreement as PDFโ Body template. Expression โEndโ is invalid due to: Expression refers to undefined fieldโฆ
Iโm using a google Doc template.
I retested after removing the blank spaces around the second โStartโ but get the same results. I double check my syntax against this article and canโt find an error, https://help.appsheet.com/en/articles/961746-template-start-expressions.
Please help me find the problem.
Would you please take a printscreen from your template. Then we can be sure what the syntax is, thanks.
Attached are screen shots. I hope these help.
What happens if you try just?
<<Start: [Related Gen_Contracts]>>
<<[vLabel]>>
<< End >>
After more testing, I discovered it has something to do with the tables in the template.
Fails:
Works:
Yes you should have Start: and End either inside of the same table or outside, but not like where Start: is outside and End is inside or the opposite.
Then itโs still puzzling why it didnโt work here. (one of the original screen captures)
Retested same definition this way:
User | Count |
---|---|
44 | |
28 | |
28 | |
21 | |
13 |