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())
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:
but this is what I get instead:
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!
This is the record detail URL in the interface.
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:
Here's your formula to use in your button:
"https://airtable.com/app...../...../" & RECORD_ID() & "?....."
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
(***** is the unique ID of the record picker)