The primary field
  • 24 Aug 2022
  • 1 Minute to read
  • Dark
    Light

The primary field

  • Dark
    Light

Article Summary

The primary field is akin to the concept of a primary key in relational databases. In Airtable, the primary field is most often a text type field. However, it can also support many other field types including, but not limited to, date, number, autonumber, and formula field types.

Overview

The primary field is always the first column in any table, and cannot be deleted, moved, or hidden. The name is meant to be a short, unique representation of each record in your table.

The primary field is required so that it can be used as a brief description of a record in other parts of the UI. For example, if you link a record to another table, we show the value of the primary field in a small card representing the linked record:

360083905693Image2020-08-04at115606AM.png

We also use the primary field as the title of record cards, which we show in the iOS app and a number of other places:

360083905993IMG0113.PNG

See also: How can I change the primary field in my table?

Supported field types

Airtable current 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

Formulas for primary fields

If your table does not lend itself particularly well to a single unique primary field, a useful technique is to set the primary field as a formula type, and to compose the name of each record using values from the other fields in your table. To learn more about how to do this, you can read Using a formula in the primary field.

360083907533Image2020-08-04at120456PM.png


Was this article helpful?