Manage your waiting list fairly and transparently
Demand is high and people want to know where they stand. A simple, fair system keeps goodwill.
Steps
- Set up a sheet: first name, date joined, area, availability, manual or auto, consent to contact.
- Run the prompt below for formulas and messages.
- Update it weekly and message people when a slot opens.
The exact prompt
Help me set up a waiting list in Google Sheets for a [UK] driving instructor. Columns: first name, date joined, area, days/times available, manual or auto, contact consent (Y/N), status. Give me: a formula for weeks waiting, a filter view for people matching an open slot [day/time/area], and 2 short messages: "you're on the list, here's what to expect" and "a slot has opened". Honest about wait times: [my estimate].
✓ Check before you send
- Wait estimates are honest.
- Contact only with consent.
- Data is deleted when no longer needed.
UK notes extra
- Keep personal data minimal and secure. GOV.UK: data protection and your business.