AppSheet Barcode Attendance - Factory and Canteen
Budget: ₹12,500 – ₹37,500 INR
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.
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.