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.










