Overview

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?

• After expanding a record, take notice of your web address bar. The url will show something like 'airtable.com/tblxxxxxxxxx/viwxxxxxxxx/recxxxxxxxx'. The 'recxxxxxxx' portion is the unique record id.
• Add a formula field and use the RECORD_ID() function to surface each unique record id in a table.

What can I do with a record id?

• Use in setting up Automations
• Use within the Scripting Block
• Create a record-specific URL using a formula field. Expand a record and wrap the text up until 'rec' in quotes followed by an ampersand (&). Then, use the RECORD_ID() function to fill in each record id dynamically.