The primary field in Airtable
Last updated: October 19, 2026
Plan availability | All plan types |
Permissions |
|
Platform(s) | Web/Browser, Mac app, and Windows app |
The primary field is always the first column, or field, in any table. It represents a description of each record in the table and cannot be deleted, moved, or hidden.
Choosing a primary field value
The primary field identifies a record wherever Airtable shows that record outside its own table. Linked record cells display the primary field value of each record they link to, and so do record previews and the expanded record title. Airtable also matches on the primary field value when you paste into a linked record field.
A primary field value that doesn't tell one record apart from another is therefore hard to read everywhere except the table the record lives in.
Airtable doesn't require primary field values to be unique, so keeping them distinct is up to you. A useful primary field value is:
Unique across the table, or close to it.
Readable on its own, without the rest of the record for context.
Short enough to read inside a linked record cell.
When a record describes an event rather than a thing-a site visit, a shift, an order-combine the few fields that together make it unique. A field visit record might combine the date, the customer, and the visit type, giving values like "2026-03-04 North Shore Hospital Pre-sale". If two people could log the same visit type at the same place on the same day, add the person's name (or some other identifier) as well.
To generate unique values automatically instead of typing them, change the primary field to a formula field, or combine a formula with an autonumber field. For more details, see our Using formulas in Airtable's primary field article.
Reviewing and editing primary fields
To review and edit a primary field:
Open your Airtable home screen.
Open your desired base.
Click the primary field's field header.
Select Edit field and click Save.
Changing primary fields
To change a primary field for a table:
Open your Airtable home screen.
Open your desired base.
Click the primary field's field header.
Click Change primary field.
Click the dropdown arrow under "Primary field" and select your desired primary field.
Click Change primary field.
When changes to a primary field are made this way, the changes will not appear in enterprise audit logs.
Duplicating information in primary fields
If you plan on editing the field type but still need what's currently stored there, we recommend creating a new field to host that information.
To create a new field storing your current primary field's information:
Open your Airtable home screen.
Open the base hosting the primary field you want to duplicate.
Click the primary field's field header.
Select Duplicate field.
Allowing you to duplicate the name, cells, or both.
Supported field types in the primary field
Airtable currently supports customizing primary fields as the following field types:
Single line text
Long text
Date
Phone number
Email
URL
Number
Currency
Percent
Duration
Formula
Autonumber
Barcode
FAQs
Can I use formulas in the primary field?
If your table requires more than a single primary field, change the primary field to a formula type and update the name of each record using values from the other fields in your table. You can read Using a formula in the primary field to learn more.