keepcalculator

06 Numbers and Powers

Airtable Basics: A Beginner’s Guide

Card No. 06·83928 · Updated · Standard formula, shown below

Airtable is a cloud-based platform that combines the structure of a spreadsheet with the power of a database, letting you organize anything from content calendars to inventory. This guide explains the core concepts, shows you how to build your first base, and covers common pitfalls so you can start productively without the overwhelm.

What Is Airtable, Really?

At its simplest, Airtable looks like a spreadsheet: rows and columns of data. But underneath, it’s a relational database. That means you can link records across tables (e.g., connect a customer to their orders) and use different views of the same data without duplicating it. For a beginner, the key difference is that Airtable lets you define field types—like checkboxes, dates, attachments, and links to other records—so your data stays structured and consistent.

It’s used by small teams, nonprofits, and even large companies for project management, CRM, event planning, content tracking, and more. The free tier is generous enough for personal projects and small teams to get real value.

Core Concepts: Bases, Tables, Fields, and Records

Everything in Airtable is organized into a hierarchy:

  • Base – A single database file (like an Excel workbook). It contains all your tables.
  • Table – A set of records with the same structure (like a sheet or a database table).
  • Field – A column that holds a specific type of data (e.g., text, number, date, attachment).
  • Record – A row in a table, representing one item (e.g., one project task, one contact).

When you create a new base, Airtable offers templates (e.g., Content Calendar, Project Tracker). You can also start from scratch. Each table comes with a primary field (usually a text field) that names each record—you can rename it to something like “Task Name” or “Email.”

How to Build Your First Base

Let’s walk through creating a simple task tracker from scratch:

  1. Click “Add a base” and choose “Start from scratch.”
  2. Rename the default table to “Tasks.”
  3. Rename the primary field to “Task Name.”
  4. Add fields: “Due Date” (Date), “Priority” (Single select with options High, Medium, Low), “Status” (Single select with Not Started, In Progress, Done), and “Assignee” (Collaborator, which lets you tag people).
  5. Click the “+” in the grid to add a few tasks with sample data.

That’s it—you’ve built a functional tracker. You can now sort by due date, filter to show only “In Progress,” and switch to a Kanban view (like Trello) by clicking “Grid” and choosing “Kanban.”

Views: Grid, Kanban, Calendar, Gallery, and More

Views are different ways to look at the same table data. They don’t change the underlying data; they just filter, sort, and group it. Key views for beginners:

  • Grid – The default spreadsheet-like view.
  • Kanban – Cards in columns (great for workflows).
  • Calendar – Shows records on a calendar based on a date field.
  • Gallery – Shows records as cards with images (good for visual content).
  • Form – A custom form to collect data from others, which goes directly into the table.

You can create multiple views of the same table—for instance, a “My Tasks” view filtered to only your assignee, and a “Team View” showing everything.

Linking Tables and Using Lookup Fields

The real power of Airtable comes from linking records between tables. For example, you might have a “Projects” table and a “Tasks” table. In the Tasks table, add a “Link to Projects” field, and choose the Projects table. Then each task can be linked to a project.

Once linked, you can add a Lookup field in the Projects table to pull in data from linked tasks, like “Count of Tasks” or “Total Estimated Hours.” This is how you build dashboards without manually updating numbers.

To create a lookup: in the Projects table, add a field, choose “Lookup,” select the linked table (Tasks), and then pick the field you want to pull (e.g., “Estimated Hours”). Airtable will show a combined value or a list, depending on the field type.

Common Mistakes and How to Avoid Them

Beginners often run into these issues:

  • Using a spreadsheet mindset – Don’t put multiple values in one cell (e.g., “John, Jane”). Use a multiple-select field or a linked table instead.
  • Ignoring field types – If you need to do math, use a number field, not text. Dates should be date fields, not text.
  • Deleting a linked field – When you delete a link field, you lose the relationships. You can’t undo that easily.
  • Not using views – Instead of creating duplicate tables, use filters and views to see different slices of data.
  • Forgetting about record limits – The free plan caps records per base at 1,000 (as of 2025). If you hit that, you need to upgrade or split data.

Also, be careful with the “Rollup” field—it’s powerful but can be confusing. It aggregates values from linked records (e.g., sum, average, count). Start with Lookup before trying Rollup.

Costs, Limits, and Alternatives

Airtable has a free plan, but it’s limited to 1,000 records per base and 2 GB of attachment storage per base. Paid plans (from around $20/user/month) remove those limits and add features like revision history and advanced permissions. For a small team, the free plan might be enough initially.

Alternatives include Google Sheets (simpler, but no relational features), Notion (more flexible but less structured), and Coda (similar to Airtable with more document-like feel). If you need offline access or very large datasets, a traditional database (like SQLite) might be better, but Airtable is easier for non-developers.

Frequently Asked Questions

Is Airtable free for personal use?

Yes, the free plan is available for unlimited bases, but each base is limited to 1,000 records and 2 GB of attachments. For most personal projects, that’s plenty.

Can I import data from Excel or Google Sheets?

Yes, you can import CSV files or directly from Google Sheets. In the base, click the grid’s “+” and choose “Import data.” You can also copy-paste from Excel.

How do I share a base with someone?

Click the “Share” button in the top right. You can invite people by email or share a view link. For a view link, they can view without an account, but to edit, they need to be added as collaborators.

What’s the difference between Lookup and Rollup?

A Lookup pulls a field value from linked records (e.g., show the project name). A Rollup aggregates values from linked records (e.g., sum of hours). Lookup is simpler; Rollup is for calculations.

Can I automate tasks in Airtable?

Yes, Airtable has built-in automations (like sending an email when a status changes) on all paid plans, and a limited number on the free plan. You can also use third-party tools like Zapier for more complex workflows.

How do I delete a base?

Go to the base’s home, click the base name, and choose “Delete base.” Be careful—deleting a base removes all tables and data permanently. You can’t undo it.

Related

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.

More cards in this drawer

The whole Numbers and Powers drawer →