Help

Re: How to create an 'Open Record' button in a table that will show record details in an interface

1598 1
cancel
Showing results for 
Search instead for 
Did you mean: 
ryanbsmith
5 - Automation Enthusiast
5 - Automation Enthusiast

Screenshot 2024-05-22 at 1.10.29 PM.png

I've done a lot of searching and tried a variety of suggestions but I can't get this to work.  I'm trying to make the viewing of record details in an interface very intuitive for the user.  Here is what I've tried:

1. Button Field URL Formula:

 

CONCATENATE("https://airtable.com/appxxxxxxx/pagxxxxxxxx" & RECORD_ID())

 

and

 

CONCATENATE("https://airtable.com/appxxxxxx/pagxxxxxx?detail=" & RECORD_ID())

 

2. Created a URL field that contains variations of the URL shown above in #1, along with a Button field that references that field in the formula.

3. I found some information that suggested how to get the URL of the record detail view in an interface, but the format of the URL looks nothing like what is posted.  This is the format I read that I'd find when I got the URL of a detailed record view:

 

https://airtable.com/tblXXXXXXXXX/viwXXXXXXXXX/recXXXXXXXXX

 

but this is what I get instead:

 

https://airtable.com/appxxxxxxxxxx/pagpxxxxxxxxxxx?detail=eyJwYWdlSWQiOiJwYWcxNWFqR0FkVm93TnF5QyIsInJvd0lkIjoicmVjQllMa2ozVE9BaXRKM3YiLCJzaG93Q29tbWVudxxxxxxxxxxxxx

 

I am not using a synced table, so I don't have the Open Record option for a button.  The closest I've gotten is that the interface opens the record detail, but also opens a new browser tab that shows the table itself.  I would greatly appreciate help with solving this!

6 Replies 6
Sho
11 - Venus
11 - Venus

Hi @ryanbsmith,

This is the record detail URL in the interface.

https://airtable.com/app~/pag~/rec~

The formula is like this

 

"https://airtable.com/app~/pag~/" & RECORD_ID()

 

This URL is shortened and changes to a complex URL when accessed.

The button field opens the URL in the same tab when clicked.
It can be opened as a new tab by Shift+click or scroll button click in the browser function.

The URL also changes depending on if it's a "Side Sheet" or a "Full Page".

Use the URL from the Full Screen version. When you swap it back to the side sheet it still connects.

The URL should look something like this:

www.airtable.com/app......./pag......./rec.......?..........

Here's your formula to use in your button:

"https://airtable.com/app...../...../" &  RECORD_ID() & "?....."

Justin Ng
Programme Coordinator at Sistema Aotearoa
https://www.sistemaaotearoa.org.nz/
ryanbsmith
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks for your response.  This is one of the variations I tried, but it doesn't work.  I see the URL briefly change in the browser, but nothing happens on the page.  Opening in a new tab also loads the interface without the detailed view.  Here's what I have as the formula:
Screenshot 2024-05-23 at 1.37.32 PM.png

Sho
11 - Venus
11 - Venus

Is "Record detail pages" set in the list of this interface?
If this is disabled, record details will not be displayed.

2024-05-24 084643.png

ryanbsmith
5 - Automation Enthusiast
5 - Automation Enthusiast

My settings appear differently, but yes.  Clicking the row does open the details, it's just that I'd like a button in the row because it's more intuitive for the user.

Screenshot 2024-05-24 at 2.31.42 PM.png

Sho
11 - Venus
11 - Venus

Unfortunately, the record detail link does not seem to work for Interfaces created from Blank layout.
If you use the List interface (not the Blank Layout), you can use the record detail URL for Level 1 records.

An alternative is to create an element on the same page that can display the record picker and record details, and set the record picker URL to a button in the List to display the details of the record selected in the List.

The URL of the record picker looks like this
https://airtable.com/app~/pag~?*****=rec~  
(***** is the unique ID of the record picker)