A browser-based visitor sign-in app for South African buildings. Captures name, company, SA ID or passport, host, reason for visit, and vehicle registration. Generates a unique reference per visit, maintains an access log with CSV export, and syncs all entries to Google Sheets in real time.
**Building Access Control** is a visitor management web app designed for South African buildings and office reception desks.
When a visitor arrives, a receptionist (or the visitor themselves) works through a clean 3-step sign-in form:
1. **Personal details** — first name, surname, company, and ID verification. The app supports both South African ID numbers (with 13-digit validation) and passports for foreign nationals.
2. **Visit details** — who they're visiting, the reason for the visit, and an optional vehicle registration number if they're parking on the premises.
3. **Confirmation** — a summary screen with the ID number partially masked for privacy, before final sign-in.
On successful sign-in, a unique reference number is generated (e.g. `BAC-K3F2A1`) and the visitor is welcomed by name.
**The access log** keeps a running record of all sign-ins with stats for total visitors, today's count, and vehicles on site. The full log can be exported as a CSV at any time.
**Google Sheets integration** lets every sign-in post automatically to a connected spreadsheet in real time, giving building management a permanent, cloud-based record. Setup takes about 3 minutes using Google Apps Script, with step-by-step instructions built into the app's Setup tab.
The app runs entirely in the browser with no server or database required — visitor data is stored locally on the device as a backup, and synced to Google Sheets as the primary record.