Airtable Cobuilder is here! Learn more about our new no-code app creation feature, powered by AI on the Airtable Academy

Page Record URL not working

783 2
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

Good afternoon,

I am attempting to create an automation that sends an email to my team with details about some work items.

We use an Interface view to organize those records, and I need to generate links to each record so that when a team member clicks it, it opens in the Interface view, not in the Data view. The default is a view that doesn't show all the data we need (instead of the view from which the automated email came from), which is annoying in the first place. I'm trying to solve that via the interface. 

I know how to generate a link to a record in the Data view, by just using the record ID. But I haven't found a way to do the same in Interfaces.

For example:

This is a link to a record in the Interface:{appid}/{pagid}?detail=eyJwYWdlSWQiOiJwYWc0UTlGcTVNcGVBeEVsRiIsInJvd0lkIjoicmVjZHMweHdocHlmVE1scEQiLCJzaG93Q29tbWVudHMiOmZhbHNlfQ

This is another one:{appid}/{pagid}?detail=eyJwYWdlSWQiOiJwYWc0UTlGcTVNcGVBeEVsRiIsInJvd0lkIjoicmVjdFludjlJNkJZWmJJUU0iLCJzaG93Q29tbWVudHMiOmZhbHNlfQ.

The two links are largely identical except for a 19-character string in the middle (in italic), which is the only difference. For the first one, that string is "ZHMweHdocHlmVE1scEQ", for the second one the string is "dFludjlJNkJZWmJJUU0".

This isn't the record ID, or any other record property I know of, and it looks like it is the key to generating these links using my automation.

I've done some looking around and couldn't find a solution. Some suggested creating a formula field like such: 

"" & RECORD_ID()

The furthest that gets me is to the interface itself, but not the record ID that I am referencing. Once the page loads, that record ID in the URL disappears. I also tried to brute this into the email itself to create a link without a formula using the "..........=[Airtable record ID]" tag in the email body itself. It has the same result. 

My problem could be solved one of two ways, if I could get the URL to work, or if I can get the Page Record URL to show my interfaces. They aren't listed, and doesn't help me solve this problem. Please see attached screenshot to see the blank Use Data From "Select a page" area. These interfaces are published and active. 

Does anyone know why my "Page Record URL" is blank? And / or does anyone know how to generate links that get the user directly to the specific record in the interface? Or where do those strings come from?

Also why does the Base Record URL point to a random view and is there a way to control that?

Thank you!

2 Replies 2
7 - App Architect
7 - App Architect

Hello @Kurt_Germaine, we've built an app just for this, and it even works if your Interface has filters:

You can even use it with the Airtable Automations "Run a script" action to generate links to the Sidesheet in your Interface automatically!

Interface Sidesheet URL Generator.gif

And you can try the script before buying it here:

6 - Interface Innovator
6 - Interface Innovator

Appreciate this, but I want to know why AT isn't seeing my interfaces in the first place, and why these old solutions don't work.