- A view changes how you see data, not the data
- Pick the type that fits the job
- Creating the view
- Collaborative, Personal or Locked
- Plan limits and the 1000-record preview
- Keeping lots of views tidy
- A content team's set of views
- How Notion and Pipedrive do views
- My advice for Airtable users
- Frequently asked questions
Open the base and table, click + Create new, choose the view type (grid, form, calendar, gallery, kanban, timeline, list or gantt), name it, choose Collaborative, Personal or Locked, and click Create new view. Then show or hide fields, and filter, group, sort or colour records to suit the job.
A view changes how you see data, not the data
Airtable describes a view as a particular way to look at and organise the underlying data in a table. A table can have many views and several view types, all showing the same records. Change a record in one view and it changes everywhere, because there's only one copy of the data. That's why views are safe to experiment with: hiding a field or filtering out rows in a view doesn't delete anything.
Pick the type that fits the job
| View type | Good for |
|---|---|
| Grid (the default) | Editing many records at once, spreadsheet style |
| Form | Collecting new records from other people |
| Calendar | Anything with a date, such as content or events |
| Gallery | Records with images, such as products or designs |
| Kanban | Work moving through stages |
| Timeline and gantt | Projects with start and end dates |
| List | A simple, readable run of records |
Creating the view
- From your Airtable home screen, open the base and then the table.
- Open the views sidebar if it's hidden, by clicking the three horizontal bars icon, then click + Create new.
- Click the type of view you want.
- Name the view and choose Collaborative, Personal or Locked.
- Click Create new view.
- Show or hide fields, and filter, group, sort or colour records.
If you already have a view set up the way you like, there's a shortcut. Use Copy another view's configuration to bring across its filters, sorts, groups and field visibility, from any view in the same table.
Collaborative, Personal or Locked
This choice decides who can change the view's set-up, not who can see the data.
- Collaborative views let all base collaborators see and edit the view's configuration.
- Personal views can only be configured by you, so your filters won't upset anyone else.
- Locked views block configuration changes until someone with Creator or Owner permissions releases the lock.
Permissions also decide what each person can do with views. Owners and Creators can create, delete, modify, print, and lock or release views. Editors can create, delete and modify views. Commenters can create, delete and modify only their own personal views.
Plan limits and the 1000-record preview
Airtable's Help Center flags two things that catch people out. Personal and locked views, favourite views and view sections are only available on higher-tier workspace plans. And a view with more than 1000 records loads as a preview: you click Load all records to see them all. If records seem to be missing from a big view, that preview is the likely reason, not a filter.
Keeping lots of views tidy
From the ... icon beside a view's name, you can duplicate, rename, favourite or delete it. Duplicating is the fastest way to make a variation, such as Drafts only from an All posts view. On plans that have them, view sections group your list into My personal views, More personal views, My favorites, custom sections and More collaborative views.
In a grid view, you can also choose a row height: Short (the default), Medium, Tall or Extra Tall. Taller rows help when long text or attachments need to be read at a glance.
A content team's set of views
Say a small marketing team tracks every blog post in one table. A grid view called All posts is the master list. A kanban view grouped by status shows Ideas, Writing, Editing and Published. A calendar view uses the publish date to show the month ahead. And a locked grid view called Published gives the boss a filtered list nobody can accidentally change. Same table, four views, each for a different job. For a more polished front end, my guide to the Airtable Interface Designer is the next step.
How Notion and Pipedrive do views
Notion's database views come in several types, and you can link a view of another database into your current one; my guide to Notion databases explains how. Pipedrive has list views and custom fields for organising CRM records. If you'd rather plan in a spreadsheet, see my walkthrough on how to build a gantt chart in a spreadsheet.
Want AI doing the heavy lifting in your marketing?
I build the systems that handle the boring 80 percent, so you get your week back. Done properly, with the human kept in.
My advice for Airtable users
Start with one view per job rather than one view that does everything. Use Personal views for your own filters, lock the ones others rely on, and copy configurations instead of rebuilding them. If a large view looks short, click Load all records before you start hunting for a broken filter.
Want your tool on this list? Featured spots and reviews here are paid partnerships. Here's how to partner with me.
Frequently asked questions
How do I create a view in Airtable?
Open the base, click + Create new, choose the type, name it and click Create new view.
What view types are there?
Grid, form, calendar, gallery, kanban, timeline, list and gantt.
What's a personal view?
One that only you can configure.
Can I lock a view?
Yes. Locked views stop collaborators changing the configuration.
Can I copy a view's filters to another view?
Yes, with Copy another view's configuration, within the same table.


