Kuovonne's Guide to Airtable

Explore

Kuovonne's Guide to Airtable

Kuovonne's Guide to Airtable

Specific Formulas

Url of Interface Page for a record

⁠

⁠ Tip Jar ⁠ Thank Kuovonne for creating this content! ⁠ ⁠ ⁠

⁠

Inspiration

When sending internal email notifications, it can be handy to include a link to the record in question. If you have a beautiful interface page, you want to include a link to the record in the interface, not the Data section of the base.

Discussion

Understanding the url for a record in an interface

You can get the url for a record in an interface when viewing the interface page in a web browser (versus the desktop app)/

If your interface page has only one record picker, the url for a record in the interface page looks like this:

https://airtable.com/appXXXXXXXXXXXXXX/pagXXXXXXXXXXXXXX/?F2o88=recXXXXXXXXXXXXXX

The first part of the url before the ? contains the base ID appXXXXXXXXXXXXXX followed by the page ID of the interface page pagXXXXXXXXXXXXXX.

https://airtable.com/appXXXXXXXXXXXXXX/pagXXXXXXXXXXXXXX/

The text after the ? identifies the ID of the record picker element (about five alphanumeric characters) and the ID of the record that is picked recXXXXXXXXXXXXXX.

F2o88=recXXXXXXXXXXXXXX

If you are editing the interface, you may also see /edit in the url before the ?. You can ignore this part when building the url for the record, as users will not be editing the interface page.

Minimal formula url

If you want a minimal formula, you can use the following format:

"https://airtable.com/appXXXXXXXXXXXXXX/pagXXXXXXXXXXXXXX?F2o88=" & RECORD_ID()

Formula url with comments

You can also use a longer formula that identifies the individual portions of the formula and lets you include the name of the interface page.

CONCATENATE(

IF("base id", "https://airtable.com/appXXXXXXXXXXXXXX/"),

IF("interface page name", "pagXXXXXXXXXXXXXX"),

IF("record picker", "?F2o88=" & RECORD_ID())

)

⁠

⁠ ⁠ Thank Kuovonne for creating this content! ⁠ Give Kuovonne a sandwich ⁠ Signup for Coda w/ referral link ⁠ ⁠ ⁠Buy from my Gumroad Store ⁠ ⁠ ⁠ ⁠ ⁠

⁠

Gallery

Want to print your doc?
This is not the way.

Try clicking the ⋯ next to your doc name or using a keyboard shortcut (

CtrlP

) instead.