I work for a TV Production Company - most of their processes are still very manual.
I would like to go “paperless” and take everything online with mostly automated systems - it would make life just so much easier on set but also afterwards for auditing proses.
I know what I want but I don’t have any / NO IDEA on how to do / set it up.
Please help and/or show me what I have to do? I don’t know App Sheet, just came accross it when I was doing research but I am so willing to learn…
I got Gemini Prompts but I don’t understand what I need to do. Any assistance in this regard will be greatly appreciated.
I basically use Google Forms that the crew needs to complete.
1 - Personal information (i.e. Master Database with document submissions - bank confirmation etc.)
2 - Dietary Requirements (for catering company)
3 - Attendance Register (crew needs to sign-in and out on a daily basis, timesheets kept and QR meal vouchers sent to be redeemed)
I want to intergrate and automate these sheets that comes from the completed Google Forms
Here are the Gemini prompts, but what do I now?
I have updated your Google Sheets structure to integrate the Master Crew List, the Morning Check-In, and the Catering Redemption into one cohesive system.
Crew Management & Catering System
[file-tag: drive-uploaded-file-1xSTfuchcVUS0nU0CJGLwef56WKNgQL3JrtIiGdlYIAA]
Sheet Architecture
The workbook is now divided into four specific areas to support your workflow:
- Master Crew List (The Database)
Columns: Unique ID, Name, Designation, Email, and QR Code Link.
QR Generation: The QR Code Link column uses a formula to automatically generate a unique QR code for every new crew member added. This is what you will send to them digitally.
- Attendance Register (The Morning “Gate”)
Columns: Timestamp, Unique ID, Name, and Status.
Logic: When a crew member scans here in the morning, the system logs them as “Active.” This “unlocks” their ability to get a meal later.
- Catering Redemption (The Digital Voucher)
Columns: Timestamp, Unique ID, Meal Type, and Voucher Valid?.
Verification: The Voucher Valid? column uses a MATCH formula to check the Attendance tab.
If the ID is found in Attendance for today: VALID (Green).
If the ID is missing: INVALID - NO CHECK-IN (Red).
- Status Dashboard (The Manager’s View)
Uses COUNTIF and COUNTA to show you real-time stats:
Total Crew vs. Total Checked-in.
Meals Served vs. Meals Remaining.
Dietary Breakdown (if you add a dietary column to the Master List).
Next Steps for Digital Distribution
To send these codes to your crew:
For AppSheet: Point your AppSheet app to the Attendance tab for the morning scan and the Catering tab for the meal scan.
*For Emailing: You can now use a Mail Merge tool (like Yet Another Mail Merge) to grab the Email and the QR Code Link from the Master Sheet and send them all out with one click
*
How do I do this? Please help me?
