Session Attendance Tracker (QR sign-in)

The problem this kills

Paper sign-in sheets are a compliance time bomb. They get coffee-stained, left in a binder, or quietly lost - and six months later an auditor asks you to prove that twelve specific people sat through the forklift safety class, and you have nothing solid to show. Even when the sheet survives, you still spend an evening squinting at handwriting, typing names into a spreadsheet, and chasing down who actually showed up versus who signed for a friend.

The manual reconciliation is worse than the lost paper. You have a roster of who was supposed to attend, a sign-in sheet of who claims they attended, and no easy way to line them up, spot the no-shows, or deal with the three people who wandered in who weren't even invited. The "who got credit" question feeds straight into certification and completion records - so a sloppy attendance log quietly corrupts everything downstream.

What you'll build

A small, private web app for your training team. You open a session, the app shows a rotating QR code or short check-in code on screen, and employees scan or type it on arrival. Each check-in is time-stamped, so your late-cutoff and partial-credit rules apply automatically. The app reconciles every check-in against the roster, flags no-shows and walk-ins (people who weren't on the list), and lets you make manual adds for the person whose phone died. Nothing becomes official until you, the instructor, review and approve the final record - then it locks, updates completion/cert status, and exports a clean CSV in the exact columns your system of record expects.

What's inside the Implementation Plan

The plan is a single file you paste into Claude Code, and it builds the whole thing with you step by step. It opens by interviewing you about your actual training operation - your roster format, your check-in preferences, your late and partial-credit rules, your messy edge cases - so the tool is tailored to how you run sessions, not a generic template. You'll get:

• A guided discovery interview that shapes the data model around your real fields and rules.
• A rotating, time-bound check-in code so people can't screenshot and share it (anti-spoofing built in).
• Roster import (Google Sheet / CSV) with a "no API yet?" fallback so you can build it today.
• Automatic no-show and walk-in detection, plus manual add/dispute handling.
• An instructor approval gate that locks the official record.
• A compliance-grade attendance CSV export.

The governance it includes (this is the point)

This isn't a toy form - it's an auditable system. The plan builds in login so only your team can use it, row-level security so each org only sees its own sessions and people, and a complete audit trail recording who checked in whom and when, every manual add, and who approved the final record. The crucial piece is the human-in-the-loop approval gate: the app drafts the reconciled attendance, but nothing is recorded as official - and nothing flows to completion or cert systems - until a person reviews and approves it. Duplicate guards mean the same employee can't be checked into the same session twice, no matter how many times they scan.

Who it's for

Trainers, safety officers, and compliance coordinators who need provable attendance for safety or regulatory training - the people who get the audit request and need to produce a defensible record in minutes, not a frantic search through old binders. If you've ever lost a sign-in sheet or hand-typed one into a spreadsheet at 9pm, this is for you.

You've got this - paste the first prompt and let the plan interview you.