Record ID
  • 25 Aug 2022
  • 1 Minute to read
  • Dark
    Light

Record ID

  • Dark
    Light

Within Airtable, each record has a unique identifier known as a Record ID. If you are familiar with Entity-Relationship Diagrams or ERDs, then the record id would be the primary key.

For most, record id's remain behind the scenes. However, learning to find and use record ids will also help you to better leverage your information organized in Airtable.

How do I find a record id?

A record ID can only be displayed when a record is expanded. To expand a record, hover over any record and look for the expand icon that will appear on the left-hand side of the record. Click the icon to expand the record.

1500002287502expandrecord.png

After expanding a record, take notice of your web address bar. The URL will show something like 'airtable.com/appxxxxxxxxx/tblxxxxxxxxx/viwxxxxxxxx/recxxxxxxxx'. The 'recxxxxxxx'portion of the URL string is the unique record id.

Using the RECORD_ID formula function

Another way to obtain a record ID is by using a formula field and the RECORD_ID()function. This function can be used to produce each unique record id in a table. To start, add a formula field to your table and input the function as shown in the example below.

360080423533Image2020-07-13at60025PM.png

Save the formula, and you'll then see the unique record ID for every record in your table.

1500002288002recordidfunction.png

What can I do with a record id?

Besides using record ID in an API integration, you can also use it when setting up automations or within the Scripting Extension.

You can additionally create a record-specific URL using a formula field. Expand a record and wrap the text up until 'recxxxxxxx' in quotes followed by an ampersand (&). Then, use the RECORD_ID() function to fill in each record id dynamically.

4420645090711recordIDformula.jpg



Was this article helpful?