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.
You type your team, your busy periods and how many people you need in each day.
The assistant asks how far ahead staff should ask and who approves.
You get the form questions, a sheet layout with a clash rule and the approve and decline messages.
What happens
Use ChatGPT to 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.
Tools
Paste the prompt, fill the blanks, copy the draft.
- ChatGPT — required. Drafts from the text you paste. Nothing is sent.
The prompt is on this page. A free account saves it.
Create a free account