How to obtain a record URL
  • 01 Jul 2022
  • 1 Minute to read
  • Dark
    Light

How to obtain a record URL

  • Dark
    Light

Intro

There are a couple of ways to obtain a record's URL. If you only need a few record URLs from time to time, then the first method will work fine. If you use record URLs often, then the second method will likely be a better option for your workflow.

Method 1

In an Airtable base simply right-click on the record that you would like to have a URL for. This will bring up a drop-down menu of options where you can click on "Copy record URL". You can share the record URL with colleagues or save it for your own use in the future.

360099114913Image2020-11-09at35020PM.png

Method 2

Alternatively, if you want to use record URLs often for collaboration or for automations, then you may want to create a formula field that concatenates together several pieces of information. For the URL to appear correctly you will need:

  1. The first part of your base's unique web address. This can include the base (app), table (tbl), and view (viw) id's for your particular base. It's worth noting that the view you are currently in is the one that will display in the link should you choose to add it. The format for this address will look like this:
"https://airtable.com/appxxxxxxxxxxxxxx"

or (including the table ):

"https://airtable.com/appxxxxxxxxxxxxxx/tblxxxxxxxxxxxxxx"

or (including the table and view ):

"https://airtable.com/appxxxxxxxxxxxxxx/tblxxxxxxxxxxxxxx/viw9xxxxxxxxxxxxxx"
  1. The RECORD_ID() for each particular record. This can be a separate Record ID formula field, or you can simply use the RECORD_ID()function in the formula that you set up. In this example, we will build the RECORD_ID() function into the formula.

4410632715287recordURLFormula.gif

We can now use the CONCATENATE()function to create a formula. This formula will produce the unique record URL for every record created in your base. In our example, the formula looks like this:

CONCATENATE("https://airtable.com/appxxxxxxxxxxxx/tblxxxxxxxxxxxx/viwxxxxxxxxxxxx/", RECORD_ID()) 
WANT TO CHOOSE WHETHER OR NOT TO SHOW OR HIDE THE EXTENSIONS DASHBOARD IN YOUR LINK?

You can add ?blocks=hideor ?blocks=showto the end of the concatenation formula. This will cause your link to either hide or show the extensions dashboard when the link is opened. This formula will look like this:

CONCATENATE("https://airtable.com/appxxxxxxxxxxxx/tblxxxxxxxxxxxxx/viwxxxxxxxxxxxxx/", RECORD_ID(),"?blocks=hide") 

Was this article helpful?

What's Next