Make an email body with two-level Start statement

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

Not 100% sure what your goal is, but please try to add your ¨Start: & End¨ formula to a separate row.

HI @Aleksi

Thanks for your quick answer.
I’m not sure I understood correctly what you told, I tried this:


and got the same error message.

My goal is to get something similar to this (this is the idea)

For doing that, you need to use nested Start: & End. Something like…

<<Start: [QuoteHeaders]>><<[Description]>>
<<Start:[Quote Details]>><<ColumnA]>>…<< End >>
<< End >>

I think that is what I did ?
Or am I miswriting something ?
In the case of a table like in the picture, I’m not sure of how the start/end statement are interpreted by the system.
Should I align very strictly the rows ?

What attracts my attention is this part of the error message : what do you think about that ?
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'?.

Let’s start by taking some complexity out of this. Remove all of the tags except the first <<Start>> and its corresponding <<End>>. Does that change the error?

Hi @Steve

with this :

that does not work.

But I think I get it : I did not notice that the template does apply to a specific database, and this one is set on “Quote”. I thought that DB was specified within the Start statement.

I will look further into it and let you know if I can get something out of it.

1 Like