Generate an attendance list for weekly meeting

UtilityWina · 02-20-2024 12:00 AM

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	EMAIL	SECTION	DATE	TIME	LOCATION	SIGN
Text	Text	Text	Email	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.

Markus_Malessa

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>>.