How do i create a report with parent child relationship tables?
I can run the report with out the table formatting just fine.
Everything works, No errors.
Once i add the expression to a table format i get the following error:
โError: Workflow rule โPCH Reportโ field โAttachmentโ expression โ[Chapter Stance]โ is invalid due to: Unable to find column โChapter Stanceโ. Error: Workflow rule โPCH Reportโ field โAttachmentโ expression โ[Standing Motion]โ is invalid due to: Unable to find column โStanding Motionโ. Error: Workflow rule โPCH Reportโ field โAttachmentโ expression โ[Chapter Comment]โ is invalid due to: Unable to find column โChapter Commentโ. Error: Workflow rule โPCH Reportโ field โAttachmentโ expression โ[Public Comments]โ is invalid due to: Unable to find column โPublic Commentsโ. Error: Workflow rule โPCH Reportโ Start expression โ[Public Comments]โ should generate a List of Ref values. Please verify that it generates a List and that the contents of the List are Ref values. Ref values should come from the โKeyโ column of the referenced table. Error: Workflow rule โPCH Reportโ Start expression โ[Public Comments]โ should generate a List of Ref values. Please verify that it generates a List and that the contents of the List are Ref values. Ref values should come from the โKeyโ column of the referenced table.โ,
Any insight would be greatly appreciated
Thank you!
I can investigate if you provide: 1. Your account id 2. The app name 3. The workflow or report name
We donโt support having a table (formatted as a Google table) within another
table (formatted as a Google table).
Put another way, only the innermost table in the hierarchy can be formatted as a Google table.
So you could modify your template as follows: 1. At the very top, your โParent Recordโ, start expression, and the four data fields are fine. They are formatted in โListโ format. 2. You can choose to format the Child records in either of the two way you do it above. You can either use the โListโ format as you do at the top, or you use the embedded child table format below.
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |