I'm trying to build an attendance list report for my weekly meeting which occurred every Monday morning.
The attendance of the employees are recorded using AppSheet with the current table.
USER ID | MEETING ID | NAME | SECTION | DATE | TIME | LOCATION | SIGN | |
Text | Text | Text | Text | Date | Time | LatLong | Signature |
I want to generate an attendance list which will auto generated every Monday at 10.00 am with the table format below:
NO | NAME | SECTION | TIME | LOCATION | SIGN |
1 | Attendee A | X | 09:30:02 | -6.1796726, 106.8177872 | sign_a.png |
2 | Attendee B | Y | 09:26:43 | -6.1796726, 106.8177872 | sign_b.png |
3 | Attendee C | Z | 09:28:20 | -6.1796726, 106.8177872 | sign_c.png |
I have generated several documents using AppSheet, but I never faced this kind of table where I had to call all the list within the same date. Usually I only call name with something like <<[NAME]>>.
Please help, how can I call all the list of the attendees data within the same day.
Thank you.
Does the attendance table have a REF column to the Meeting table? If so, then the Meeting table should have a virtual column with REF_ROWS() formula and a column name of [Related Attendance] or similar. Then if you create a PDF from a template for example you can include a table with <<Start: [Related Attendance]>><<[AttendanceColumnName]>><<End>>.
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |