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

Prompt

Act as an Airtable schema cartographer who only uses a pasted table inventory. You write a schema and relation map the inventory already supports. You do not invent record counts, sync quotas, automation run totals, or API keys not in Inputs. This is not an Airtable billing estimate and not a data-migration contract.
You work only from Inputs. Do not invent stats, citations, quotes, URLs, names, IDs, or records that are not in Inputs.

Inputs:
- Table inventory I lock (table stubs, field cues, link notes): [Inventory]
- Airtable / base version notes I lock: [Version]
- Base or workspace label I may quote (or UNKNOWN): [Workspace]
- Required schema or view names I may quote (or UNKNOWN): [SpecNames]
- Table titles already present (or UNKNOWN): [TableCues]
- Field type labels already present (or UNKNOWN): [FieldCues]
- Link and view notes already present (or UNKNOWN): [LinkNotes]
- Words I must not use: [Banned]
- What I must never invent (record counts, sync quotas, automation run totals, API keys): [Never]
- Output format: [Format]
- Language: [Lang]

Generate:
1. Honesty ledger: Inventory nouns, Version, Workspace, SpecNames, TableCues, FieldCues, LinkNotes, Lang. Forbidden: invented record counts, sync quotas, automation run totals, API keys. Banner: not an Airtable billing estimate; not a data-migration contract.
2. Schema relation map: one numbered row per Inventory table stub or field cue. Missing LinkNotes write NOT IN INPUTS. Use Airtable Bases, Tables, Linked Records, Views, and Interfaces language when Inventory supports it. Never print record-count or sync-quota VALUES not in Inventory.
3. Spec name set: only names in SpecNames. Unnamed views stay NOT IN INPUTS. Never invent automation-run 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 sync quotas, inventing automation run totals, inventing API keys.
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 schema and relation maps, 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 Schema Relation Map from Table Inventory (No Invented Record Counts) - Result

Examples

Example Input

Inventory: table Harbor Quay Projects as pasted field cue Status single select as pasted link notes linked to Tasks as pasted; table River Ops Tasks as pasted field cue Due Date as pasted. Record invent NONE. Sync invent NONE.
Version: Airtable Interface Designer as pasted (do not invent unreleased Omni pack)
Workspace: Harbor Quay ops base as pasted
SpecNames: Projects schema map as pasted; Tasks schema map as pasted. Automation UNKNOWN.
TableCues: Projects as pasted; Tasks as pasted. Clients UNKNOWN.
FieldCues: Status single select as pasted; Due Date as pasted. Owner UNKNOWN.
LinkNotes: linked to Tasks as pasted. Record count VALUES NOT IN INPUTS.
Banned: guaranteed records, record invent, sync invent, API key invent
Never: invent record counts, invent sync quotas, invent automation run totals, invent API keys
Format: ledger + table + specs + version + refuse + compliance
Lang: English

Example Output

1. Ledger. Inventory: table Harbor Quay Projects field cue Status single select link notes linked to Tasks; table River Ops Tasks field cue Due Date. Record invent NONE. Sync invent NONE. Version Airtable Interface Designer. Workspace Harbor Quay ops base. SpecNames Projects schema map; Tasks schema map; Automation UNKNOWN. TableCues Projects; Tasks; Clients UNKNOWN. FieldCues Status single select; Due Date; Owner UNKNOWN. LinkNotes linked to Tasks; Record count VALUES NOT IN INPUTS. Lang English. Banner: not an Airtable billing estimate; not a data-migration contract. Forbidden: invented record counts, sync quotas, automation run totals, API keys, guaranteed records, record invent, sync invent, API key invent.

3. Spec name set. Projects schema map; Tasks schema map as SpecNames. Automation UNKNOWN so write automation NOT IN INPUTS. No record-count VALUES beyond Inventory. No third table invented.

4. Version lock. Airtable Interface Designer as pasted. Unreleased Omni pack not used. Owner FieldCues NOT IN INPUTS.

5. Refuse. Record invent: refused. Sync invent: refused. Automation invent: refused. API key invent: refused. Guaranteed records: refused.

6. Compliance. Banned hits none. Format ledger+table+specs+version+refuse+compliance. Gaps: automation policy, Clients TableCues, Owner FieldCues, record count VALUES LinkNotes, Views list 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.