Template start expression empty result

[d1scover]

Hi ! 

I'm new with App Sheet, and I'm struggling to use the <<Start: >> expression in my Google docs template.

I have 2 tables, "Invoices" : 

and "Services" :

There is a one-to-many relationship between "Invoices" and "Services" : an Invoice contains different services, and a service is only linked to one invoice.

My goal : for every created invoice, generate a PDF that lists the invoice's information, and the related services.

To list the related services, I understand I have to use the <<Start: > expression.

If I understand correctly, I try to achieve "Reverse reference" as described in the doc : https://support.google.com/appsheet/answer/11541779

So here's what I tried in my google docs template file : 

<<Start: [Related Services]>>

<<[Service Name]>>

<<End>>

But this produces an empty text on my generated PDF.

Anyone knows what I'm doing wrong ?

Thanks for your help !

[baba_sawane]

Hi d1scover,

Your expression is correct. I don't exactly know why it doesn't work... Try to put your columns within a table : 

<<Start:[Related Services]>>

<<[Service name]>>

 <<End>>

[d1scover]

Hi baba_sawane !

I tried your suggestion but I'm still getting an empty result for this expression. 
I can access the columns of "Invoices" from my template, but I can't manage to access the related "Services" ...

I'll keep searching, thanks for your help !

[Aurelien]

Can you please make sure:

1) in your template, the whole <<Start:>> ...<<End>> has the exact same typo and layout

2) for the specific record you are running test, you really have services attached. One common mistake is to run a test on the first row...which has no related services 🙂

[d1scover]

Hi @Aurelien ,

thanks for your help, my problem was solved following @SkrOYC 's answer.

Thanks for your time, and have a nice day !

[SkrOYC · Accepted solution]

---

@d1scover wrote:

for every created invoice, generate a PDF that lists the invoice's information, and the related services

---

If you are running the event on paren'ts add, the children are not created yet when the bot runs.

Example automations - AppSheet Help

[d1scover]

Thank you @SkrOYC  !

I was investigating something like this, and this is exactly what the problem was.

After following the tutorial on your link, everyone works now fine!

Thanks for your precious help, and have a nice day

[GUS123]

YO TAMBIEN TENGO ESE PROBLEMA ME PODRIAS AYUDAR NO ENTIENDO MUY BIEN LO DE CREAR DOS ACCIONES COMPUESTAS