Open this file in a text editor and replace SUPABASE_URL and SUPABASE_ANON_KEY near the top of the <script> section with your project's values. Full instructions are in SETUP_GUIDE.md.
Edits save automatically when you click out of a box. Grey boxes are read-only for you.
Sundays are already Holiday and Saturdays are already WFH — no request needed for those. Use this for leave, or to work from home on any other day.
Create a space in Google Chat (e.g. Team Pulse), add everyone, then Apps & integrations → Webhooks → Add webhook, and paste the URL here. Punch-ins, punch-outs, leave requests and all reminders post there. Steps are in NOTIFICATIONS_GUIDE.md.
Nudges go out every 15 minutes, up to 6 times per item per day, and are skipped for anyone on approved leave. Requires the reminder engine to be deployed (UPGRADE_GUIDE.md).
Attendance is calculated from punch times only — nobody can type their own hours. You can still override any single day from the sheet.
Anything below the half-day threshold — including a day with no punch at all — counts as Leave. Sundays are Holiday and Saturdays read as WFH automatically.
Punching in from one of these connections counts as being in the office. Saturdays and approved work-from-home are exempt; anything else is flagged in red on the sheet and alerts you on Google Chat.
Only these email addresses can create an account. Anyone else is refused by the database itself, so the app URL can be shared safely.
Phone numbers are used once you switch reminders to WhatsApp. Format: +919876543210
