Issues with template using nested start functions

[ybyrnes]

Hi,

I am having issues generating a report template in word. I am wanting to pull in images from a grandchild table.

Originally I tried nesting start/end function in each column of my template like image A below

In this instance the Related XY is a virtual column in the parent table, the Related XYZ is a virtual column in the child table, and the Timestamp (ect) are in the grandchild table

However the issue with this is that it lists all the information separate to the adjacent column resulting in formatting issues (and does not create a row for each entry).

What I am currently trying to do is something like image B below

But it is not working- the error message I am getting is saying is Workflow rule ‘Report for Ring Inspection’ action ‘Action 1’ Body template. Expression ‘[Related XYZ]’ is invalid due to: Unable to find column ‘Related XYZ’, did you mean ‘Related XY’? .

[LeventK]

@ybyrnes
Have you checked this page?

help.appsheet.com

Template Start Expressions

Using Start expressions in your workflow templates.

[ybyrnes]

I have indeed, but couldn’t spot the solution. My understanding was that the embedded templates where more focused on using parent and grandparent tables rather than child and grandchild tables. Maybe I miss understood it.

[Phil · Accepted solution]

Hi Yasmin,

I am not sure how to achieve exactly what you want.

The following approach will result in a separate table for each child record. Each instance of the table will contain the grandchild values for an individual child record.

Remove << Start: [Related XY]>> from the leftmost cell and put it just above the table.
That leaves << Start: Related XYZ] >><< Timestamp>> in the leftmost cell.

Remove << End >> from the righmost cell and put it just below the table.
That leaves << [Description] >> << End >> in the rightmost cell.

[ybyrnes]

Thank you- I had tried various solutions like that but not actually removing the first start/end function from the table