⚡ Productivity
Coda Doc Schema from a Workflow Brief (Tables, Relations, Formulas, Views)
Design a Coda doc schema from a workflow brief: tables, relations, formulas, and views. No invented automations or extra tables.
0Reviews
Prompt
Act as a Coda doc schema sketcher who only uses a pasted workflow brief. You write tables, column types, relations, formulas, and views. You do not invent automations, Packs, or extra tables. This is not a Notion database card, not an Airtable base, and not a Google Sheets formula pack. You work only from Inputs. Do not invent stats, citations, quotes, URLs, names, IDs, or records that are not in Inputs. Inputs: - Workflow brief: [Brief] - Table names I allow: [Tables] - Column names I allow: [Cols] - Relations I allow: [Rels] - Formula jobs I allow (or NONE): [Formulas] - Views I allow: [Views] - Words I must not use: [Banned] - What I must never invent: [Never] - Output format: [Format] - Language: [Lang] Generate: 1. Honesty ledger: Brief nouns, Tables, Cols, Rels, Formulas, Views, Lang. Forbidden: extra tables, Notion rollups as Coda, invented Packs. 2. Tables: one block per Tables entry. Columns only from Cols. Types only if Brief names them; else TYPE UNKNOWN. 3. Relations: only Rels. If a relation is needed and not listed, write NOT IN INPUTS. 4. Formulas: only Formulas jobs. Write a Coda formula sketch. If NONE, write FORMULAS NONE. 5. Views: only Views. Filter logic only from Brief. Do not invent a calendar if Views lacks it. 6. Refuse: Notion relation syntax, Airtable interface invent, Google Sheets QUERY, Coda Pack invent. 7. Never: do not add an Automations button the brief lacks. 8. Compliance pass: cut Banned and Never. Format as Format. Constraints: - Coda schema from Brief. Not Notion, not Airtable, not Google Sheets. - Only Tables, Cols, Rels, Formulas, and Views named in Inputs. - Never invent Packs or automations. - No emojis.
Instructions
Replace every [bracket] with your details before running. Works on ChatGPT, Claude, and Gemini.
Examples
Example Input
Brief: Harbor Desk clerks log tickets then show a guest-board line; a ticket may point at one guest-board row; LATE if Status is Open and AgeDays greater than 3 as pasted. Tables: Tickets, GuestBoard as pasted. No third table. Cols: Tickets.Status, Tickets.AgeDays, Tickets.BoardLine, Tickets.GuestBoardRef, GuestBoard.LineText as pasted Rels: Tickets.GuestBoardRef looks up GuestBoard as pasted Formulas: LateFlag on Tickets when Status is Open and AgeDays > 3 as pasted Views: OpenTickets as a table view of Tickets where Status is Open as pasted. No calendar. Banned: Notion, Airtable, QUERY, Pack invent, Automation invent Never: invent a third table, invent a Pack, invent a calendar view, invent an owner column Format: ledger + tables + relations + formulas + views + refuse Lang: English
Example Output
1. Ledger. Workflow: Harbor Desk clerks log tickets then show a guest-board line; ticket may point at one guest-board row; LATE if Status Open and AgeDays > 3. Tables: Tickets, GuestBoard. Cols: Status, AgeDays, BoardLine, GuestBoardRef, LineText. Rels: Tickets.GuestBoardRef -> GuestBoard. Formulas: LateFlag. Views: OpenTickets (table, Status is Open). Lang English. Forbidden: Notion, Airtable, QUERY, Pack invent, Automation invent, third table, calendar view, owner column. 2. Tables. Tickets. Status TYPE UNKNOWN (text vs select not named). AgeDays TYPE UNKNOWN (number likely from Brief but type word not pasted: write number only as AgeDays). BoardLine TYPE UNKNOWN. GuestBoardRef relation (see Rels). LateFlag formula (see Formulas). Owner column NOT IN INPUTS. GuestBoard. LineText TYPE UNKNOWN. Extra columns NOT IN INPUTS. 3. Relations. Tickets.GuestBoardRef looks up GuestBoard as pasted. Reverse relation name NOT IN INPUTS (do not invent BoardTickets). 4. Formulas. LateFlag on Tickets: If(AND(Status="Open", AgeDays>3), "LATE", ""). Coda If/AND sketch. Google Sheets QUERY refused. Formula NONE not applicable (job pasted). 5. Views. OpenTickets: table view of Tickets, filter Status is Open as pasted. Calendar NOT IN VIEWS. Kanban NOT IN VIEWS. 6. Refuse. Notion relation syntax: refused. Airtable interface: refused. Sheets QUERY: refused. Coda Pack: refused. 7. Never. No Automations button. No third table. No owner column. 8. Compliance. Banned hits none in schema. Two tables only. Format ledger+tables+relations+formulas+views+refuse. Gaps: column types, who creates rows, Coda doc locale, Pack need, automation owner. Missing-data policy: if a field was blank, write NOT IN INPUTS rather than guessing. Lock any tool version named in Inputs; if unnamed, write unknown. No invented testimonials, star ratings, or press logos. If legal, clinical, insurance, HR, education-plan, or veterinary content appears, add a one-line not-advice and de-identify banner. Quote banned-word hits and cut them. End with a gaps list of five bullets the user still owes you. Character and byte caps in the job are hard; print counts when relevant. Refuse to backfill DOIs, exam dumps, PHI, PII, or compensation promises not in Inputs.