PDF Template - Start expression in table - move up 2 tables

[chacal3351]

Hi all,

I have 3 tables:

 MainProject - MainProjectID

 Addons - AddonsID / MainProjectID / AddonsNumber / Price

 Invoice - InvoiceID / MainProjectID / MonthlyBill

I am trying to build an Invoice template with a table with a Start expression listing all the addons of the main project:

Addons	Price
<<[Start]:MainProject[RelatedADDONSs]>><<[AddonsNumber]>>	<<[Price]>><<[End]>>

When testing, it returns the following error:

Found 1 unmatched 'Start'...

Can anyone help me out?

Many thanks.

Matt

[jaichith]

you should use separate start and end expression for each table in the template. 

Reference to use start and end

[chacal3351]

Hey jaichith.

Thanks for you reply, I still don't get how to do what you suggest...

I have tried multiple options and still the same return.

Matt

[AleksiAlkio]

I assume you are triggering the Bot from the Invoice table and its record. Then you would need to use something like..

<<START: SELECT(Addons[AddonsID],[MainProjectID]=[_THISROW].[MainProjectID])>><<[AddonsNumber]>><<End>>

[chacal3351]

Hey AleksiAlkio

Thanks for your reply!

I was indeed triggering the bot from the Invoice table in the first place. I have tried your solution, I am still getting the error...

I finally decided to trigger from the Main Project table. 

I then have:

Addons	Price
<<Start:[RelatedADDONSs]>><<[AddonsID]>>	<<[Price]>><<[End]>>

I still get the error. I do not understand. I have created other templates prior to this one, with the same set up, and they work fine. 

Why this one is not working is a mystery to me...

I know it is doable. I just cannot get my head around it...

[AleksiAlkio · Accepted solution]

Instead of using <<[End]>>, you should write just <<End>>.

[chacal3351]

Blimey...

Stupidest mistake ever!

Thanks!

[AleksiAlkio]

You're welcome!