When building an attendance management application in AppSheet, one important consideration is how attendance sessions are controlled.
For example, in a system where attendance is recorded during scheduled services or events, administrators need to control when check-ins are allowed.
One approach is to create a dedicated Attendance Sessions table and connect attendance records to individual sessions.
This structure can help to:
-
Associate each attendance record with a specific session.
-
Track whether a session is open or closed.
-
Control when new attendance records can be submitted.
-
Maintain an organised attendance history.
-
Give administrators better control over attendance activities.
I’ve been exploring this approach while developing King’s Presence, an attendance management system built with AppSheet and Google Sheets.
It’s been a useful project for understanding how data structure, expressions, and interface design work together in a practical application.
I’d be interested in hearing how other AppSheet developers handle session-based attendance and record restrictions in their own applications.