Template
Reports 2 - Grouped PDF
How to create a grouped PDF
This app demonstrates how to setup a grouped PDF - using a nested START expression in your template.
In reality what I'm demonstrating here, is how to access data from different "levels" inside your PDF template.
- From the "Grandchild" you can access the "Parent"
- From level 5, access levels 2 AND 4
Loading...
Also see:
tablet mode & fullscreen mode
How we built this app
You'll need to adjust your Report table & the template for this to work; you'll also need a separate table to hold records that correspond to the groups you wish to work with.
1) First you need a table to hold the records that correspond to each group
2) Then, in your Reports table, you need a list of the groupings to show in the PDF
2) Finally you need to adjust your template to account for the groups
- This is where the nested START expression comes into play
Learn more about how to access data from various levels in your PDF template here:
https://support.google.com/appsheet/answer/11541779?hl=en#:~:text=evaluated%20five%20times.-,Access%20columns%20in%20parent%20and%20grandparent%20records,-Within%20an%20embedded
This is a preview of the data sets used in the app.
Data
This is a high-level model of both the data entities and the UI elements in the app.
Loading...