Home · Jobs & career · Take staff holiday requests on a form that flags clashes
Take staff holiday requests on a form that flags clashes
Two people book the same week off by text and you only notice on the Monday. Get a holiday request form and a sheet that turns red when cover's too thin.
The prompt · ChatGPT
Help me set up a staff holiday request form and tracker. My business: [what you do] Team: [names and roles] Minimum people needed each day: [e.g. 2 in the kitchen, 1 on the counter] Busy periods: [e.g. December, school holidays] How much notice I want: [e.g. 4 weeks] Who approves: [me, or a manager] Ask me up to 3 short questions first if anything important is missing. Wait for my answers. Then: 1. The Google Form questions: name (dropdown), first day off, last day off, half or full days, reason (optional), cover arranged. 2. A sheet layout from the form responses, with a status column (pending, approved, declined). 3. A conditional formatting rule that colours a request when it overlaps someone in the same role. 4. Short approve and decline messages, with the decline offering other dates. 5. A one-paragraph holiday request policy to share with the team. Check holiday entitlement rules on GOV.UK rather than stating them. Only use what I've told you, leave blanks for anything I haven't given, and don't invent facts or figures. UK English. Stay in this ChatGPT chat. Do not turn on apps or connectors, and do not use memory from another chat.
A short example
Fill the blanks, then paste. what you do: a short note you already have. names and roles: a short note you already have. Leave the rest of the prompt as written.
Loading the outline…