Make an email body with two-level Start statement

dev2
New Member

Hi there,

I would like to send an email based on two tables. First one is a list of headers, second one the attached details.
The purpose is to send a formatted invoice, with headers and details below.

Iโ€™m struggling about the correct statement, though I found a similar post without solution.
I deal with 4 tables:

  • Quote: list of quotes
  • QuoteHeaders: list of headers
  • Quote Details: every specifications related to the quote header, such as products or services
  • TableTestDevis: list of products and services

Here is my statement:

<<Start:[QuoteHeaders]>><<[Description]>>
<<Start:[Quote Details]>> <<TableTestDevis[Code].[Nom]>>
<<End>>
<<End>>

And here is a screenshot of the table I would like to display

For any reason I donโ€™t understand, I get an error message. Here is the log:

Error: Workflow rule โ€˜Show me the Invoice!โ€™ action โ€˜Action 1โ€™ Body template. Expression โ€˜Start:[QuoteHeaders]โ€™ is invalid due to: Unable to find table โ€˜START:โ€™, did you mean โ€˜Quoteโ€™?.
Error: Workflow rule โ€˜Show me the Invoice!โ€™ action โ€˜Action 1โ€™ Body template. Expression โ€˜[Description]โ€™ is invalid due to: Unable to find column โ€˜Descriptionโ€™.
Error: Workflow rule โ€˜Show me the Invoice!โ€™ action โ€˜Action 1โ€™ Body template. Expression โ€˜Endโ€™ is invalid due to: Expression refers to undefined field.",

As I understand it, it does not seem to catch the table โ€œQuoteHeadersโ€ (I checked the name).
Any clue ? Are my Start/End statement incorrect ?

Many thanks in advance

0 13 389
13 REPLIES 13
Top Labels in this Space