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.
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 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/tblxxxxxxxxxxxxxx"
or (including the view):
"https://airtable.com/tblxxxxxxxxxxxxxx/viw9xxxxxxxxxxxxxx"
2. 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.
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/tblxxxxxxxxxxxx/viwxxxxxxxxxxxx/", RECORD_ID())
?blocks=hide
or ?blocks=show
to the end of the concatenation formula. This will cause your link to either hide or show the Apps dashboard when the link is opened. This formula will look like this:CONCATENATE("https://airtable.com/tblxxxxxxxxxxxxx/viwxxxxxxxxxxxxx/", RECORD_ID(),"?blocks=hide")