I need a Google AppSheet app that lets my office and canteen staff manage attendance and meal charges simply by scanning the standard UPC codes printed on employee badges. Here’s the day-to-day flow I’m aiming for: a staff member points an Android phone at a badge, AppSheet grabs the UPC, time-stamps the entry, and if the employee buys food, records the items and prices in the same session. At closing time the app should email or save a PDF/Sheet summary showing who came in, how long they stayed, and what they spent. Core functions to build into the AppSheet tables and views • Record entry and exit times on every scan (one tap to flip between IN and OUT). • Track meal purchases against the same badge and date. • Auto-generate daily, weekly, and monthly attendance/finance reports. Environment & constraints • Data must live in Google Sheets. • Scans happen on Android phones/tablets using AppSheet’s built-in barcode scanner. • Only office and canteen staff will access the app, so the UI can stay lean and staff-centric. • Any App Script automation should stay inside the same Workspace. No external services. Acceptance criteria 1. Deployable via AppSheet link with permission control for five test users. 2. A test scan writes a row to “Attendance” and, when a meal is added, to “Meals”. 3. End-of-day “Reports” view emails a PDF/CSV summary without manual triggers. Deliverables • Transfer of the working AppSheet app to my domain. • Brief setup guide or Loom walkthrough so I can maintain it.