Having a sub list in a template - getting crazy here

[Anthony_DEDE]

Hi,

I am getting crazy here and everything attempted does not seem to work!

Here the matter: I have a table of PV (PV_VIN with id idPV) each PV have at least one Damage (from table PV_DAMAGES with idDamage (also external key idPV))

I want in the template to have data of the PV and list of som of the items of PV_DAMAGES
like this (see below) 

the issue is with the formating on the start that does ,not seems to work  depending how I do it 
<<Start :select(PV_DAMAGES[Location],[idPV]=[idPV])>><<[Location]>>  

or <<Start:[PV_DAMAGES]>><<[Location]>>

nothing is working any clue what might be wrong here?

Information du Vehicule / Vehicle informations
VIN	<<[VIN]>>	Vehicle protection Covering	<<[Vehicle protection]>>	KM
Marque Brand	<<[Brand]>>	Couleur Color	<<[Color]>>	Type d’énergie Energie Type
Modèle Model	<<[Model]>>	Propreté extérieur External Cleanliness	<<[Cleanness Ext.]>>	Niveau d’Energie Energie level
Statut Vehicule Status	<<[Vehicle status]>>	Propreté intérieur Inside Cleanliness	<<[Cleanness Int.]>>
Immatriculation License Plate	<<[Licence plate]>>	Véhicule en panne Vehicule breakdown	<<[Vehicle breakdown]>>

Avaries / Damages list
N°	Localisation Location	Position	Dégâts Damage	Taille size	Sévérité Gravité	Origine Origine
1	<<Start:[PV_DAMAGES]>><<[Location]>>	<<[Position]>>	<<[Damage]>>	<<[Size (In cm)]>>	<<[Acceptability]>>	<<[Origin]>><<END>>

[AleksiAlkio · Accepted solution]

First check that the column name you use with the START: expression is the key column. Then you need to use something like SELECT(....,[idPV]=[_THISROW].[idPV)

[jballester]

hi
have you checked Monitor bot execution?
https://support.google.com/appsheet/answer/11447502?#h_b4e2781c1e

[Anthony_DEDE]

Yes, but did not helped (at least I knew some issue with syntax)

[Anthony_DEDE]

Thanks I am trying it now ! 😉

[Anthony_DEDE]

Ok trying this one

<<Start:select(PV_DAMAGES[idDamage],[idPV]=[idPV])>><<[Location]>>

<<[Position]>>

<<[Damage]>>

<<[Size (In cm)]>>

<<[Acceptability]>>

<<[Origin]>><<END>>

I have the column populated now but the data set was not filtered as asked. a clue what whent wrong here?

[Anthony_DEDE]

Oups forgot the "[_THISROW]"

[Anthony_DEDE]

Thanks Aleksi, you helped me fixed the issue !

[AleksiAlkio]

You're welcome!