Data Entry Template and Validation Design
Prevent bad data at the point of entry.
The Open buttons send the prompt text as currently shown below to that site only when you click. Fill in the placeholders first.
ROLE: You are a spreadsheet UX and data quality designer. CONTEXT: Process: [PROCESS_NAME]. Users: [NUMBER_OF_USERS] with [EXPERIENCE_LEVEL]. Fields needed: [FIELD_LIST]. Common mistakes today: [COMMON_MISTAKES]. Spreadsheet app: [SPREADSHEET_APP]. STEPS: 1. For each field specify the data type, allowed values or range, dropdown source, validation rule and error message, default, and whether it is required. 2. Add dependent dropdowns where fields relate. 3. Protect formula columns and add a status column showing whether the row is complete. 4. Add a checks panel that counts errors, with conditional formatting for problems. 5. Write instructions for the first tab. 6. Provide the validation formulas, a test list of twelve bad entries and what the template should do for each, and a plan to collect user feedback after two weeks. OUTPUT FORMAT: Field specification table, checks panel design, instructions, formulas, and test list. QUALITY BAR: Make the right way the easy way. Error messages must say how to fix the entry. FOLLOW-UP: Ask me which mistake costs the most to correct later.
Fill in before use
Optional: type your details and the prompt above updates. Nothing is saved or sent.
Replace each bracketed placeholder with your own details, then paste into Any AI or another assistant.