I need a self-contained, Google Apps Script-driven kiosk system that runs in a browser window on an in-store tablet. The interface should feel professional and clean, matching the layout shown in the PDF I will supply. All data sits in Google Sheets; Apps Script will act as the controller, pushing and pulling records and showing real-time information to our freelancers. Core workflow – Freelancers arrive, open the kiosk, and can: • view the latest project data fed from Sheets • fill out structured forms that write straight back to specific tabs • approve or reject entries, with the status instantly updated in the sheet • optionally tab for “change music” action, which spotify or other players are used. On a second tablet we’ll present a customer consent form. It must capture: personal information, terms and conditions acknowledgement, and a handwritten signature field. If it’s technically straightforward, I’d also like the option to snap a licence or ID photo and link it to the same row in the backend sheet. Deliverables 1. Google Apps Script code for both kiosks, fully commented. 2. Linked Google Sheets structure with example data and any helper formulas. 3. A published web-app URL or easy deployment steps so I can test on our tablets. 4. Brief hand-off notes explaining how to adjust information, add and remove freelancers colours, text, or add new form fields. I’ll judge completion once the demo runs smoothly on two Chromebooks in kiosk mode, data flows without manual refresh, and the UI mirrors the PDF mock-ups