How to structure file template for related data from multiple tables

[SIDHR]

I have created an app to prepare quotation for construction works using standard BOQ structure. The related tables are as follows:-

Quotes

QuoteWorkSections

QuoteWorkSectionSubcategories

QuoteWorkSectionSubcategorySpecifications

QuoteWorkSectionSubcategorySpecificationWorks

I would like to generate a table with the structure shown below.  NB Each level may have multiple sub levels

Item	Description	Qty	Unit	Rate	Amount
A	QuoteWorkSectionSubcategories(1)
	QuoteWorkSections(1.1)
	QuoteWorkSectionSubcategories(1.1.1)
	QuoteWorkSectionSubcategorySpecifications(1.1.1.1)
	QuoteWorkSectionSubcategorySpecificationWorks(1.1.1.1)

I have completed the app and happy with it. Just need some help to write the data to a pdf document in the above format.

Thanks

[dbaum · Accepted solution]

Sorry. It looks like I pasted the link wrong. Here's the info: https://support.google.com/appsheet/answer/11541779?hl=en#:~:text=A%20template%20may%20contain%20one.... 

[dbaum]

Use nested start expressions.

[SIDHR]

Looks like this link is no longer active.

[dbaum · Accepted solution]

Sorry. It looks like I pasted the link wrong. Here's the info: https://support.google.com/appsheet/answer/11541779?hl=en#:~:text=A%20template%20may%20contain%20one.... 

[SIDHR · Accepted solution]

Ok This link works and it is very interesting. I will surely try it in future. However while waiting I had a go at using appscript and it did the trick

[SIDHR]

I have ended up using google script to create the file in google sheet.