QR Code Chore Auto Log System

---

---

I help run a nonprofit hostel, where guests are asked to pitch in by doing a nightly chore to help keep the place clean. I’ve been working on a system that assigns chores using a QR code. The idea is that when the QR code is scanned, it randomly selects a chore from a weighted list (so some chores show up more often than others). Once a chore is assigned, it's removed from the list for the rest of the day to avoid duplicates. Each time the QR code is scanned, I want the system to automatically log the date, time, and selected chore into a Google Sheet. Additionally, the list of available chores should reset every day at 4 PM. I’ve been using GitHub and Google Sheets to try to build this system. I got close to making it all work, but I ran into issues mostly with the automatic logging to the spreadsheet. I tried using Grok, but the autofill part didn’t quite work consistently. To summarize: -QR code that guests scan to receive their assigned chore, randomly assigned with some weights. - No duplicate chores once scanned from all devices. - Log each scan automatically to a Google Sheet, recording: Date Time Assigned chore - Reset the list of available chores daily at 4 PM, so all chores become available again. -Must work without requiring guests to log in to a Google account when scanning the QR code. Let me know if this is something you can help us with. Thanks so much

Keyword: Mobile App

Price: $50.0

JavaScript HTML