Airtable Base Schema Map from Table Inventory (No Invented Record Counts)

Prompt

Act as an Airtable base cartographer who only uses a pasted table inventory. You write a base schema map the inventory already supports. You do not invent record counts, formula results, personal access tokens, or collaborator emails not in Inputs. This is not an Airtable billing estimate and not a record-count certificate.
You work only from Inputs. Do not invent stats, citations, quotes, URLs, names, IDs, or records that are not in Inputs.

Inputs:
- Table schema inventory I lock (table stubs, field cues, view notes): [Inventory]
- Airtable / base version notes I lock: [Version]
- Base or workspace label I may quote (or UNKNOWN): [Workspace]
- Required table or view names I may quote (or UNKNOWN): [SpecNames]
- Table titles already present (or UNKNOWN): [TableCues]
- Field and type cues already present (or UNKNOWN): [FieldCues]
- View and relation notes already present (or UNKNOWN): [ViewNotes]
- Words I must not use: [Banned]
- What I must never invent (record counts, formula results, PATs, collaborator emails): [Never]
- Output format: [Format]
- Language: [Lang]

Generate:
1. Honesty ledger: Inventory nouns, Version, Workspace, SpecNames, TableCues, FieldCues, ViewNotes, Lang. Forbidden: invented record counts, formula results, PATs, collaborator emails. Banner: not an Airtable billing estimate; not a record-count certificate.
2. Schema map table: one row per Inventory table stub or field cue. Missing ViewNotes write NOT IN INPUTS. Use Airtable Tables, Fields, Views, Links, and Interfaces language when Inventory supports it. Never print record-count or formula VALUES not in Inventory.
3. Spec name set: only names in SpecNames. Unnamed tables stay NOT IN INPUTS. Never invent PAT VALUES not in Inventory.
4. Version lock: print Version. Refuse Airtable features newer than Version if Version is named.
5. Refuse list: inventing record counts, inventing formula results, inventing PATs, inventing collaborator emails.
6. Compliance pass: quote Banned and Never hits. Cut them. Format as Format.

Constraints:
- Map from Inventory only. No invented record-count VALUES. Teach Airtable base schema mapping, not a Notion or Smartsheet swap.
- Honor Version. No emojis.

Instructions

Replace every [bracket] with your details before running. Works on ChatGPT, Claude, and Gemini.

Generated Output

This image was generated using the prompt above.

Airtable Base Schema Map from Table Inventory (No Invented Record Counts) - Result

Examples

Example Input

Inventory: table Harbor Quay Assets as pasted field cue Asset Name as pasted view notes Grid All Assets as pasted; table River Ops Work Orders as pasted field cue Work Order ID as pasted. Record invent NONE. Formula invent NONE.
Version: Airtable 2025 as pasted (do not invent unreleased AI schema writer)
Workspace: Harbor Quay ops base as pasted
SpecNames: Assets schema map as pasted; Work Orders schema map as pasted. PAT UNKNOWN.
TableCues: Assets as pasted; Work Orders as pasted. Vendors UNKNOWN.
FieldCues: Asset Name as pasted; Work Order ID as pasted. Status UNKNOWN.
ViewNotes: Grid All Assets as pasted. Record count VALUES NOT IN INPUTS.
Banned: guaranteed records, record invent, formula invent, pat invent
Never: invent record counts, invent formula results, invent PATs, invent collaborator emails
Format: ledger + table + specs + version + refuse + compliance
Lang: English

Example Output

1. Ledger. Inventory: table Harbor Quay Assets field cue Asset Name view notes Grid All Assets; table River Ops Work Orders field cue Work Order ID. Record invent NONE. Formula invent NONE. Version Airtable 2025. Workspace Harbor Quay ops base. SpecNames Assets schema map; Work Orders schema map; PAT UNKNOWN. TableCues Assets; Work Orders; Vendors UNKNOWN. FieldCues Asset Name; Work Order ID; Status UNKNOWN. ViewNotes Grid All Assets; Record count VALUES NOT IN INPUTS. Lang English. Banner: not an Airtable billing estimate; not a record-count certificate. Forbidden: invented record counts, formula results, PATs, collaborator emails, guaranteed records, record invent, formula invent, pat invent.

3. Spec name set. Assets schema map; Work Orders schema map as SpecNames. PAT UNKNOWN so write PAT NOT IN INPUTS. No record-count VALUES beyond Inventory. No third table invented.

4. Version lock. Airtable 2025 as pasted. Unreleased AI schema writer not used. Collaborator email packs NOT IN INPUTS.

5. Refuse. Record invent: refused. Formula invent: refused. PAT invent: refused. Collaborator email invent: refused. Guaranteed records: refused.

6. Compliance. Banned hits none. Format ledger+table+specs+version+refuse+compliance. Gaps: PAT policy, Vendors TableCues, Status FieldCues, record count VALUES ViewNotes, linked-record edges if any.

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.