Local template
Codex Sites Restaurant Operations Dashboard Template
Shift notes, inventory issues, repairs, reservations, daily sales and staff updates. Includes a full prompt, suggested pages, D1 schema, R2 decision, access model, testing checklist and follow-up prompts.
Full Codex Sites prompt
@Sites Build an internal app: Restaurant Operations Dashboard. Goal: Create shift notes, inventory issues, repairs, reservations, daily sales and staff updates. Users: Workspace members who own the local workflow. Core pages: 1. Home dashboard with recent activity and open work 2. Searchable record library with filters 3. Detail page with status, owner, notes and history 4. Admin create/edit view with validation 5. Feedback or request form for missing information Data: Use D1 for title, category, owner, status, tags, last_updated, notes and priority. Use R2 only when files need to be uploaded directly. Access: Start with workspace access. Keep edit actions limited to the responsible owner or admin group. Quality: Add empty states, sample records, error states, responsive layout and a testing checklist. Before deployment, save a version first and show source changes, storage schema and access assumptions for review.
Build notes
- D1 recommended for structured records, owners, status, tags and update history.
- R2 is optional and should be used only if uploaded files are part of the workflow.
- Use workspace access first; ask Codex to separate viewer and editor behavior.
- Save a version before deployment and inspect storage, permissions and source changes.
- If public domain access is mandatory, move the result into a repo-backed host.