Hi All,
I am currently creating an automation to "create new file" (generate pdf). I have 3 tables: Parent (Purchase Order), Child: (Order Detail), Grandchild (Cylinder Details). When i am creating this automation using the parent table, by default it gives me the parent and child. However, i need the grandchild data also. I have tried using the below syntax in the automation file but it doesn't work. The child key is referenced to parent and the grandchild is referenced to child. Please help me.
Syntax that didnt work
Purchase Order
Order ID: <<[Order ID]>>
Customer Name: <<[Customer Name]>>
Customer address: <<[Customer address]>>
<<Start: [Related OrderDetails]>>
Order Detail
Job ID: <<[Job ID]>>
Gas Type: <<[Gas Type]>>
Volume Type: <<[Volume Type]>>
<<Start: [Related CylinderDetails]>>
Cylinder Detail
Unique ID: <<[Unique ID]>>
QR code: <<[QR code]>>
<<End>>
<<End>>
LinkedIn
Twitter
