Start function in pdf create process

I have a simple app for creating transport and invoicing documents, when creating the pdf of the invoice I need to indicate the transport documents and the items relating to each document, with the start function the first table was simple, but I can't to select only the items of the transport documents linked only to that invoice. Is there a missing table "related" between the invoices and the articles?

This is the function I'm trying to create, is there anyone who has already made a similar template? I think it's quite common but I can't get out

 

<<start:SELECT(righeDdt[ID_righeDdt],([ID_alfa3cod] = [_THISROW].[Alfa3Cod]))>><<[ID_righeDDt]>><<End>>

 

CleanShot 2022-03-02 at 07.26.00.pngCleanShot 2022-03-02 at 07.35.19.png

0 2 94
2 REPLIES 2

https://help.appsheet.com/en/articles/961746-template-start-expressions

https://www.googlecloudcommunity.com/gc/Tips-Tricks/When-to-use-thisrow/m-p/332009

Since you have embedded SELECT statements, you need to make sure that you are using the right notation to specify the right columns in the right SELECT statement which involves using [_THISROW-n].

Just general watch-outs (I have not analyzed your expressions in detail ๐Ÿ˜…

That is, unlike in normal functions within start I must also refer to the father-child table with _Thisrow? I try Thanks for your help

Top Labels in this Space