Project
Attendance Management and Tracking
Record keeping and supporting small organisations
Highlights
- Role-based permissions across four roles, with an editable grid and safety rails so the organisation can't lock itself out
- Tamper-evident audit log: hash-chained entries with an integrity check
- Privacy by default: contact details masked, each chorister gets a private personal link
Replaced a paper roll and a stack of spreadsheets for a 170-year-old choir with a bespoke web platform. Choristers sign themselves in via a QR code on their own phone, and the committee gets attendance rates, concert rosters and eligibility reporting that were previously reconciled by hand.
Integrates with the tools the organisation already used rather than replacing them: live webhook ingest from JotForm, member records linked to MembershipWorks by ID, Microsoft 365 single sign-on, ICS calendar sync, and a read-only feed into Power BI.
Built for a volunteer-run organisation on a small budget, PHP 8 and SQLite on shared hosting and no monthly platform fees.
Handles messy real-world data honestly: six years and ~15,000 attendance records migrated, with fuzzy identity matching that proposes matches for typos and nicknames but always leaves the decision to a human, rather than silently guessing.
