10 Airtable Tips Every Beginner Should Know

Build a CRM in Airtable: Step-by-Step Template

A lightweight CRM built in Airtable gives small teams the flexibility of a spreadsheet with the structure of a database. Below is a concise, practical step-by-step template you can implement in under an hour to track leads, conversations, deals, and activities.

What this template includes

• Tables: Contacts, Companies, Deals, Activities, Pipelines
• Key fields: Names, Email, Phone, Company link, Deal value, Stage, Close date, Next activity
• Views: Pipeline kanban, Active deals, Overdue activities, Contact list, Company directory
• Automations (examples): Follow-up reminders, stage-change notifications, deal close summary emails

Step 1 — Create the base and tables

1. Create a new base from scratch and name it “CRM”.
2. Add these tables:
   • Contacts — store people (one record per person).
   • Companies — store organizations.
   • Deals — opportunities tied to contacts/companies.
   • Activities — calls, emails, meetings, tasks.
   • Pipelines — optional lookup/reference for sales stages and probability.

Step 2 — Define core fields for each table

Contacts table (minimum fields):

• Name (Single line text)
• Email (Email)
• Phone (Phone)
• Company (Linked record → Companies)
• Primary Deal (Linked record → Deals, optional)
• Status (Single select: Lead, Contacted, Qualified, Customer, Do Not Contact)
• Owner (Collaborator)
• Notes (Long text)

Companies table:

• Company Name (Single line text)
• Website (URL)
• Industry (Single select)
• Location (Single line text)
• Primary Contact (Linked record → Contacts)
• Open Deals (Linked record → Deals, auto-populated)
• Account Owner (Collaborator)

Deals table:

• Deal Name (Single line text)
• Company (Linked record → Companies)
• Primary Contact (Linked record → Contacts)
• Value (Currency)
• Stage (Single select: Prospecting, Qualified, Proposal, Negotiation, Closed Won, Closed Lost)
• Close Date (Date)
• Probability (Number or formula)
• Owner (Collaborator)
• Pipeline (Linked record → Pipelines, optional)
• Notes (Long text)

Activities table:

• Activity (Single line text)
• Type (Single select: Call, Email, Meeting, Task)
• Related Deal (Linked record → Deals)
• Related Contact (Linked record → Contacts)
• Due Date (Date & time)
• Status (Single select: Planned, Completed, Overdue)
• Owner (Collaborator)
• Outcome (Single line text)
• Details (Long text)

Pipelines table (optional):

• Pipeline Name (Single line text)
• Stage (Single select or linked records)
• Default Probability (Number)

Step 3 — Create useful views

• Deals → Kanban view grouped by Stage for pipeline visualization.
• Deals → Grid view filtered: Stage != Closed Won & Stage != Closed Lost (Active deals).
• Activities → Calendar view by Due Date for scheduling.
• Contacts → Grid view sorted by Status then Owner.
• Companies → Gallery view for quick browsing.

Step 4 — Add formulas and rollups

• In Deals, add Expected Value formula: Value(Probability / 100).
• In Companies, add rollup Total Pipeline that sums related deal Values.
• In Contacts, rollup Open Deals Count to count linked deals.

Example formula for Probability (in Deals) if using Stage: Use a nested IF or SWITCH:

Code
Copy CodeCopied
SWITCH({Stage}, “Prospecting”, 10, “Qualified”, 30, “Proposal”, 60, “Negotiation”, 80, “Closed Won”, 100, “Closed Lost”, 0, 30) 

Expected Value:

Code
Copy CodeCopied
{Value} * ({Probability} / 100) 

Step 5 — Automations to reduce manual work

1. Reminder for upcoming activity:
   • Trigger: When record in Activities matches Due Date is within 1 day and Status = Planned.
   • Action: Send email to Owner or Slack message.
2. New lead assignment:
   • Trigger: When new Contact is created.
   • Action: Send notification to sales rota or assign Owner with a script.
3. Stage-change notification:
   • Trigger: When Deal’s Stage changes to Closed Won.
   • Action: Send summary email to finance and account owner.
4. Create follow-up activity automatically when Deal moves to Proposal:
   • Trigger: Deal Stage changes to Proposal.
   • Action: Create Activity record with Due Date = Today + 3 days.

Step 6 — Templates and record buttons

• Create an activity template (pre-filled Type, Status, Owner) for common follow-ups.
• Add a button field to Deals labeled “Log Call” that creates a new Activity record linked to the Deal and pre-fills Type=Call and Due Date=now.

Step 7 — Permissions and collaborators

• Set base-level permissions: Editors for sales reps, Read-only for executives.
• Use field-level editing where needed (Airtable Interface Designer or locked views