Prompt Library

ChatGPT Prompts for Airtable (Bases, Formulas, Automations)

20 copy-paste prompts

20 copy-paste ChatGPT prompts for Airtable: base design, formula writing, automations, views, interfaces, and the workflows that turn Airtable from spreadsheet-with-extras into operational platform.

Base Design

4 prompts

Base Schema from Use Case

1/20

Design Airtable base for [use case — CRM, project management, content calendar, etc.]. Output: tables (entities), fields per table, primary key, linked records (relationships), views per audience. Schema upfront = sustainable base.

Designs Airtable base schemas.

💡

Pro tip: Spreadsheet-thinking → bad Airtable. Database-thinking (separate tables, linked relationships) = Airtable's strength. Take 30 min to model schema before building.

Junction Tables for Many-to-Many

2/20

Many-to-many relationship between [Table A] and [Table B]. Output: junction table design, fields needed (link to A, link to B, plus relationship metadata), views, formulas. Many-to-many requires junction.

Builds junction tables.

💡

Pro tip: Direct M:M relationship = data integrity issues. Junction table (e.g., "Projects ↔ People" = "Project Memberships") = clean. Standard database pattern.

Field Type Selection

3/20

For [data type], best field type? Options: single line, long text, number, date, single select, multi select, attachment, link, formula, rollup, lookup. Output: recommendation with reason. Right type = better data.

Selects Airtable field types.

💡

Pro tip: Wrong field type = data quality issues. "Status" as long text = inconsistent. As single select = consistent + filterable. Field type defines data quality.

View Strategy

4/20

Design views for [base + audience]. Per audience: which view (filter + sort + group), color coding, hidden fields. Same data, different views per role. Views = role-based access.

Designs Airtable views.

💡

Pro tip: Single view for everyone = nobody finds what they need. Role-based views = each user sees relevant slice. Same data, different presentation.

Prompts get you started. Tutorials level you up.

A growing library of 300+ hands-on AI tutorials. New tutorials added every week.

Start 7-Day Free Trial

Formulas + Computed Fields

4 prompts

Formula Writing

5/20

Airtable formula for [calculation]. Context: [field references]. Output: formula syntax, explanation per function, common errors, alternatives. Test in field; don't deploy without verification.

Writes Airtable formulas.

💡

Pro tip: Airtable formulas have own syntax (slightly different from Excel). AI helps draft + explain; test in actual field. Hallucinated functions possible.

Rollup vs Lookup vs Formula

6/20

Decision: rollup vs lookup vs formula for [field need]. Lookup = pull single value from linked record. Rollup = aggregate (count/sum/etc.) of linked records. Formula = calculation within record.

Decides computed field type.

💡

Pro tip: Each computed field type has specific use. Lookup = "show me X from related". Rollup = "count related items". Formula = "calculate from this row". Mismatched = wrong result.

Conditional Formula Logic

7/20

Conditional logic in formula. Output: IF / SWITCH / nested IF, when each appropriate, performance considerations, readability. Complex conditionals = bug risk.

Builds conditional formulas.

💡

Pro tip: Nested IFs deep = unreadable + buggy. SWITCH for many conditions = cleaner. Most users default to nested IF; SWITCH is the upgrade.

Date Formula Patterns

8/20

Date formulas: days between, age, business days, fiscal year, status by date, etc. Output: formula library for common patterns. Date math common in projects, HR, finance bases.

Writes date formulas.

💡

Pro tip: Date math = top formula category. Reusable patterns (days since, business days, fiscal year) save repeated effort. Build library once.

Automations

4 prompts

Automation from Description

9/20

Airtable automation for [trigger + action]. Output: trigger type (record matches conditions, scheduled, form submitted), action sequence, conditions, error handling. No-code automation.

Designs Airtable automations.

💡

Pro tip: Airtable automations (built-in) = no-code workflow. Trigger → action (notification, update, create record). Simpler than Zapier for Airtable-internal automation.

Notification Automation

10/20

Notify [team] when [condition]. Output: trigger (record matches), notification destination (email, Slack via integration, in-Airtable), message template (with field values). Real-time team awareness.

Builds notification automations.

💡

Pro tip: Automatic notification on data change = team aware. Without = team misses status changes. Most teams underuse Airtable notifications.

Scheduled Reports

11/20

Scheduled summary report. Frequency: [weekly / monthly]. Output: time-based trigger, summary view of base, email distribution, format. Replaces "send the latest data" emails.

Schedules data reports.

💡

Pro tip: Manual weekly reports = forgotten or skipped. Automated = consistent. Same effort once; runs forever. Compounded value.

Multi-Step Automation Logic

12/20

Complex multi-step automation: [describe]. Output: trigger, sequential actions, conditional branches, error handling, monitoring. Beyond basic notifications.

Builds complex automations.

💡

Pro tip: Multi-step automations replace human handoff loops. "Form submitted → assign owner → notify → wait → escalate if no response" = automated coordination.

Like these prompts? There are full tutorials behind them.

Learn the workflows, not just the prompts. 300+ easy-to-follow tutorials inside AI Academy — and growing every week.

Try AI Academy Free

Interfaces + Sharing

4 prompts

Interface Design for [Use Case]

13/20

Design Airtable Interface for [audience + purpose]. Output: dashboard layout, key metrics, filters, action buttons, mobile considerations. Interfaces = polished UI on top of base.

Designs Airtable Interfaces.

💡

Pro tip: Interfaces = Airtable's app-builder layer. Hide raw base; show curated views to stakeholders. Most Airtable users skip; the polish layer differentiates.

Share Strategy

14/20

Sharing strategy for [base]. Output: who sees what (role-based), Interfaces vs base access, external sharing (link with restrictions), permission audit cadence. Default sharing = security risk.

Plans Airtable sharing.

💡

Pro tip: Default Airtable sharing = whole base. Selective via Interfaces = users see only what they need. Better permissions + better UX.

Form Strategy

15/20

Airtable form for [intake]. Output: field selection (don't show all base fields), form logic (conditional questions), submission notifications, deduplication. Forms feed bases reliably.

Builds Airtable forms.

💡

Pro tip: Airtable forms feed records into base. Better than Google Forms when need to live in Airtable workflow. Form-to-record-to-automation = pipeline.

External User Workflow

16/20

Workflow for external users (clients, contractors). Output: read-only Interface, form for submissions, comments, restricted views. External should see polished, not raw.

Builds external workflows.

💡

Pro tip: External users seeing raw Airtable = confusion + data exposure. Polished Interface = professional + secure. Investment in external UX = retention + brand.

Frequently Asked Questions

Airtable: database with spreadsheet UI, automations, interfaces. Notion: docs + databases, cohesive workspace. Spreadsheets: free, simple, breaks at scale. Choose by primary need: structured data (Airtable), docs+data (Notion).
Free tier: 1000 records/base. Paid: $20-45/user/mo. Worth it when: structured data critical, automations save hours, team-sized base. Not worth it for small data + occasional use.
For mid-complexity ops (CRM, project management, content): yes for many teams. For high-volume (>50K records), high-performance, complex queries: traditional database wins. Most teams: Airtable plenty.
If Excel-fluent: similar logic, slight syntax differences. If new to formulas: learning curve like Excel. AI helps significantly. Master 10 patterns = 80% of typical needs.
Schema design upfront. Most users build organically + regret structure later. 30 min planning saves hours of restructuring. Database-thinking (linked records, junction tables) > spreadsheet-thinking.

Prompts are the starting line. Tutorials are the finish.

A growing library of 300+ hands-on tutorials on ChatGPT, Claude, Midjourney, and 50+ AI tools. New tutorials added every week.

Start 7-Day Free TrialExplore AI for Project Managers

7-day free trial. Cancel anytime.

Browse All Prompt Collections