How to Use Airtable: The Beginner's Guide (First Base, Linked Records, Views, and Your First Automation)

CodexFuse Team · 2026-10-28T18:44:13.433Z · 15 min read

Learning how to use Airtable is easier than the word "database" makes it sound. Airtable looks like a spreadsheet, behaves like a database, and lets a beginner build a working tracker — for clients, content, inventory, or household projects — in a single afternoon, without writing code. This guide to Airtable for beginners walks you through the whole first-use system in order: sign up, build your first base, set up tables and fields, link records between tables, switch views, share the base, and turn on your first automation.

By the end you will have a real base of your own, not just a tour of the buttons.

If you think in rows and columns, you already know half of Airtable. Our Google Sheets beginner guide covers the spreadsheet habits that transfer directly — one row per item, one column per fact, and filters that hide everything you do not need right now. This Airtable tutorial assumes no database experience at all.

What is Airtable, exactly?

Airtable is a cloud-based relational database with a spreadsheet-style interface: you type into rows and columns the way you would in a spreadsheet, but the tables inside a base can link to each other, so the same fact is stored once and shown everywhere it is needed. That combination is the whole product. It replaces disconnected spreadsheets with one base where clients, projects, and tasks stay connected instead of drifting apart across files.

Airtable is built for freelancers, small teams, and anyone tracking work that has relationships in it — a client who has several projects, a project that has many tasks, a product that has many orders. If your tracker is really a list with no relationships, a plain spreadsheet is simpler. If the same names keep reappearing across sheets and you keep fixing them in three places, Airtable earns its keep.

What are the four words that make Airtable click?

Learn four words and the whole product clicks: a base is a project folder, a table is a sheet inside it, a field is a column, and a record is a row. Every screen in Airtable is one of those four things, and every tutorial that confuses beginners is really just using those words without defining them.

The most common beginner mistake is building one giant table with everything in it. Resist that. One table per kind of thing, linked together, is what makes Airtable different from a spreadsheet — and it is what makes the rest of this guide work.

How do I create my first Airtable base?

Creating your first Airtable base takes about five minutes: sign up free, pick a workspace, and start from a template or a blank base. Starting from a template is the faster first lesson, because you see a finished structure before you build your own.

1. Sign up at Airtable with an email address, or continue with a Google account or Apple ID, then confirm your email address from the message Airtable sends you.
2. On your home screen, click "Create a base" (or "Add a base") in your workspace.
3. Choose "Start from scratch" for a blank base you design yourself, or pick a template from the gallery that matches your project, such as a content calendar or a project tracker.
4. Name the base for the project it holds, not for the tool — "Freelance Work" beats "My Airtable" when you have five bases six months from now.
5. If you already have data, use "Add or import" to bring in a spreadsheet instead of retyping it; check that dates, names, and status values land in the right columns before you build on top of them.

Your first base should be small and real. A tracker for your actual work, with ten or twenty records, teaches you more than a template stuffed with sample data you will never touch.

What fields should my first table have?

Your first table needs a primary field, one field per fact, and the right field type for each fact — because the field type is what stops bad data getting in. The primary field is the first column, and it names the record: the project name, the client name, or the task title. Everything else hangs off it.

Double-click a column header to change its field type, then save. The types a beginner uses most are single line text for names, single select for short choice lists such as Status, date for deadlines, checkbox for yes-or-no flags, attachment for files, and user for assigning a teammate.

Keep field names short and consistent, and do not store two facts in one field. "Website redesign — urgent" in a single text field cannot be filtered by urgency; a Status field and a Priority field can.

How do Airtable linked records work?

Airtable linked records connect a record in one table to a record in another table, so you pick the client or project from a list instead of retyping it — and when the source changes, every linked view updates. This is the feature that turns a spreadsheet into a database, and it is worth learning slowly.

1. Create a second table — for example, a Projects table next to your Tasks table.
2. In the Tasks table, add a field and choose "Link to another record" as the field type.
3. Select the Projects table, then create the field.
4. In any task row, click the plus sign inside the new link field and choose the project that task belongs to.
5. Open the Projects table: Airtable has automatically added a reciprocal link field listing every task linked to that project.

Two follow-on field types build on links, and beginners mix them up. A lookup pulls a value from a linked record into the current table — for example, showing a client's email on each of their tasks without retyping it. A rollup calculates across linked records — for example, counting completed tasks, or showing what percentage of a project's tasks are done.

Here is the rollup that makes a project dashboard feel alive. In the Projects table, add a rollup field, point it at the Tasks link field and the task Status field, and use the aggregation formula COUNTIF(values, "Done") / COUNTA(values), formatted as a percent. Each project now shows its own completion percentage, updated automatically as tasks move to Done.

One truth saves hours of confusion: a lookup or rollup can only display data that already exists through a link. If your lookup cell is blank, the record probably is not actually linked yet — typing a name that looks like a link is not a link. Click into the linked record field, connect the records for real, and the lookup fills in.

Which Airtable views should a beginner use?

Airtable views are saved ways of looking at the same records — the data stays in one table, and each view shows it differently. Create a view from the sidebar, choose its type, and tell it which field to group, sort, or date by.

Timeline and Gantt views, which show date ranges as bars, come with paid plans rather than the free plan. For a beginner, Grid plus one Kanban view plus one Calendar view covers nearly every daily workflow.

Three view tools do most of the organizing: filters hide records that do not match (for example, "My Tasks" shows only records assigned to you), sorting orders what remains, and grouping stacks records under shared values such as Status or Assignee. A filtered view is also the safest way to share: share the view that shows only what someone needs, not the whole base.

If a Kanban board is the part of Airtable you love most, it is worth knowing the dedicated board tool too. Our Trello beginner guide covers boards as the whole product, while Airtable's Kanban is one view of a much larger database.

How do I share a base and keep it tidy?

Sharing a base means inviting people to it and giving each person an access level that matches what they should do — and the safest default is the lowest level that still lets them work. You can invite team members to a base, comment on records, and mention teammates, so discussion stays attached to the record it is about instead of scattered across chat messages.

Start with three habits. First, share views, not just bases, when someone only needs one slice of the data. Second, agree on who may create or delete records before the base grows, because a shared base with no rules fills with duplicates fast.

Third, take a snapshot before a big restructure: snapshots back up a base's data, but a base restored from a snapshot does not carry its revision history, so treat snapshots as restore points, not as a full undo history.

For a simple front end over your base, Interface Designer lets you drag fields into a custom layout and share that layout with teammates or stakeholders, so they work with a clean screen instead of the raw grid. It is the feature to reach for when someone says Airtable "looks too complicated" — they probably need an interface, not a smaller base.

How do Airtable automations work?

Airtable automations follow a trigger-and-action rule: when something happens, Airtable does something else automatically, without you watching the base. A trigger is the event, such as a record matching a condition; an action is the result, such as sending an email or updating a record.

Build your first automation — a "task finished" email — like this:

1. Open your base and click the Automations tab, then "Create an automation".
2. Choose the trigger "When a record matches conditions".
3. Set the condition to: when the task Status is Done.
4. Add the action "Send an email", write the message, and pull the task name and assignee in as dynamic tokens so each email names the right task.
5. Test it on one record, then turn the automation on.

Two limits decide how far automations go on the free plan. The free plan allows 100 automation runs per workspace each month, and a run is counted every time a trigger fires — whether or not the actions do anything useful. Keep conditions narrow (Status is Done, not "record updated") so routine edits do not burn your monthly runs.

When a workflow needs to connect Airtable to apps outside it, or to run on a schedule with many steps, a dedicated automation tool is the right next step. Our Zapier beginner guide covers multi-app workflows, while Airtable's own automations are best for jobs that live inside one base.

What does Airtable cost in 2026?

Airtable is free to start, and the free plan is genuinely usable for learning and for small personal projects — but its caps arrive sooner than most beginners expect. Check the pricing page before you build anything large, because plan limits change and the pricing page is the authoritative source.

When you hit a record or attachment limit, Airtable keeps your data — nothing is deleted — but you cannot add more records or attachments until you upgrade. Team costs $20 per user per month when billed annually and raises the record cap to 50,000 per base with 25,000 automation runs per workspace each month.

Business costs $45 per user per month when billed annually. For a solo beginner, the honest rule is simple: start free, and pay only when a specific limit is actually blocking real work.

Airtable vs Notion: which one should a beginner pick?

Airtable vs Notion comes down to what your work is made of: Airtable is a relational database wearing a spreadsheet's face, while Notion is an all-in-one workspace built around documents, pages, and wikis. If your project is mostly writing, notes, and docs with some tables inside, Notion feels natural. If your project is mostly structured records with relationships — clients, orders, tasks, inventory — Airtable's links, lookups, and rollups do work Notion tables struggle with.

Many people end up using both: Airtable for the tracker, Notion for the docs. Our Notion beginner guide covers the workspace side, so you can compare the two from real first-use steps rather than from feature lists.

A complete first base you can copy: the freelance content tracker

This is the smallest base that teaches every skill in this guide, and you can build it in under an hour. It has two tables, one link, one lookup, one rollup, three views, and one automation — nothing more.

Build it in this order. First, create the Projects table and add three real projects. Second, create the Tasks table and link each task to its project.

Third, add the Percent Complete rollup on Projects using COUNTIF(values, "Done") / COUNTA(values) over the Tasks link, formatted as a percent. Fourth, add a Kanban view grouped by Status, a Calendar view on Due Date, and a filtered Grid view called "My Tasks" showing only records assigned to you. Fifth, add the automation from the previous section so finishing a task sends an email.

The test that proves you understand it: change a task's status to Done and watch the project's Percent Complete move, then change a project's name and watch the linked tasks show the new name everywhere. If both updates flow through without retyping, you are no longer using a spreadsheet — you are using a database.

What mistakes do Airtable beginners keep making?

Most Airtable beginner mistakes come from treating it like a spreadsheet after the first week. The five below account for nearly all of them, and each one is easy to avoid once you have seen it named.

• One giant table instead of linked tables. If you are copying the same client name, price, or email into many rows, that fact deserves its own table and a link.
• Typed names instead of real links. A name typed into a text field looks connected but is not — lookups and rollups built on it stay blank, because they can only read actual links.
• Trying to edit a lookup field. A lookup mirrors a value from a linked record, so it is read-only by design. Change the value on the linked record and the lookup updates everywhere.
• Automations with conditions that are too broad. A trigger on "record updated" fires on every edit and burns the 100 free monthly runs fast. Trigger on a specific condition, such as Status becoming Done.
• Attaching everything. The free plan's 1 GB attachment cap per base is the limit most beginners hit first. Attach small files, and link large ones from your file storage instead.

One safety rule belongs in every beginner guide: never paste real API keys or access tokens into a shared base, a form description, or an automation message. If a token has ever been pasted somewhere shared, revoke it and make a new one — a leaked token cannot be made secret again by deleting the paste.

Sources

• Airtable — Pricing page (checked October 28, 2026): Free plan at no cost; Team $20 per user per month and Business $45 per user per month when billed annually; plans charged per seat; over-limit behavior for records, attachments, automations, and API calls.
• Airtable Support — Lookup field overview (checked October 28, 2026): lookup prerequisites, why empty lookups mean records are not linked, rollup ARRAYJOIN example, and why lookup fields are read-only.
• Tech Company News — How to Use Airtable: Step by Step Guide for Beginners (published May 15, 2026; checked October 28, 2026): base, table, field, and record definitions; the seven setup steps; the Projects and Tasks structure; the COUNTIF rollup for percent complete; the "when a record matches conditions" automation.
• Cloudwards — Airtable Review 2026 (checked October 28, 2026): sign-up and email confirmation steps, base creation from scratch or templates, views including Grid, Kanban, Calendar, Gallery, and Form, Interface Designer, trigger-and-action automations, and the snapshot rule that restored bases do not carry revision history.
• Zentor — Airtable Free Plan Limits: Every Wall Explained (numbers read from Airtable's plan comparison table on October 21, 2026; checked October 28, 2026): 1,000 records per base, 1 GB attachments per base, 100 automation runs and 1,000 API calls per workspace per month, 2 weeks of revision history, 5 editors.
• Automatic Nation — Airtable Automation Limits (checked against Airtable's automation help article on October 13, 2026; checked October 28, 2026): Free 100 runs per workspace per month, 75 automations per base, runs counted on every trigger fire, monthly reset on the first of the month.
• Switch Labs — Beginner's Guide to Using Airtable for Project Management and Database Tasks (checked October 28, 2026): the ten-step beginner path from templates and bases through views, filters, sorting, grouping, sharing, and integrations.

Frequently Asked Questions

Is Airtable free?

Yes, Airtable has a free plan at no cost, built for individuals, very small teams, and lightweight projects. It covers 1,000 records per base, 1 GB of attachments per base, and 100 automation runs per workspace each month. When you hit a record or attachment limit, your data stays, but you cannot add more until you upgrade — Team is $20 per user per month billed annually.

Do I need to know databases to use Airtable?

No. If you can use a spreadsheet, you can use Airtable: records are rows, fields are columns, and you learn the database part — linked records — by connecting two tables once. Start with the freelance content tracker in this guide, and the database ideas arrive through doing, not through theory.

What is the difference between Airtable and a spreadsheet?

A spreadsheet stores the same fact in many places, so fixing it means fixing it everywhere. Airtable stores each fact once in its own table and links to it, so a change flows through every view automatically. That is why lookups and rollups exist in Airtable and why a spreadsheet needs copy-and-paste formulas to fake them.

Why is my Airtable lookup field blank?

Almost always because the records are not actually linked yet. A lookup can only display data that exists through a link, so a typed name that looks connected still leaves the lookup empty. Click into the linked record field, connect the records for real, and check that the source field has a value in the linked record.

What happens when I hit Airtable's free plan limits?

Your data is never deleted, but adding stops: you cannot add records or attachments past their caps until you upgrade, and automations and API calls stop at their monthly caps until the month resets. The fix is usually to archive old records, link large files instead of attaching them, or narrow your automations so they fire only on the condition that matters.