Hi There - The following template placeholders/expressions will print each Parent, followed by their children:
<<Start: Parents(ParentID)>><> <<Select(Children[ChildName], [ParentID]=[_Thisrow-1].[ParentID]>>
However, the Children will be listed one after the other, separated by commas, ie:
Parent Child1, Child2, Child3
Is there a way for the Children to be listed with line feeds, like this?
Parent Child1 Child2 Child3
From what Iโve learnt about the workflow-template-pdf process, I think this could be tricky, but I thought Iโd ask.
Have you tried another Start/Edit formula inside the main Start/End?
Create a 1x1 table inside of the main table (inside of the cell) and add that Child Start/End formula there.
That was some pretty impressive lateral thinking on your part!
Thank you.
Iโll try it later, today.
Youโre welcome
Could you share the embedded Child Start/End expression you used?
It will save me a lot of trial and error.
Thanks. I figured that your [Related Inspections] is the virtual column in your Parent table that holds the list of related Child rows for each Parent row.
Just so someone else reading this understands that.
Correct
Hi Aleksi - Iโve been trying a number of ways of nesting Start/Ends.
When they are inside a table, I keep getting errors.
The best I have done, so far, is to have each Parent columns in a single row template table, with the related Child rows on separate lines underneath, and for this to repeat for all Parent records.
I did this by having the initial โParentโ <> above the template table and all the Parent columns within the template table, then the โChildโ <<Start/End>> template under the template table, then the final โParentโ <> under that.
Whenever I try to have the nested โChildโ <<Start/End>> within the template table, I get errors where Appsheet canโt recognise the Parent columns.
So frustrating, but then printing database info always is!
So you donโt think it is possible to have a nested โChildโ template show each Child on a separate line, within a โParentโ template table?
I can understand that the formatting would be difficult.
Yes, Iโd managed to do that (image1), as well as having the child rows ([Measure]) in the table, but separated by commas, rather than on separate lines (image2), but I canโt produce something like the mock-up, below (image3).
I guess Iโm trying to emulate how a pivot table would present information, which I suspect is not possible in Appsheet at this stage.
How aboutโฆ
I havenโt tested in that way but at least you can do that if you create a simple table for your child records.
User | Count |
---|---|
40 | |
34 | |
29 | |
23 | |
17 |