Help

Re: Interface Timeline Formula

Solved
Jump to Solution
714 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Scott_Gardner1
7 - App Architect
7 - App Architect

I am looking to find a formula that takes you right to the Interface from the source table, with the record expanded on the right side inside the Interface and also specific to what ever is pre-selected on the "Drop Down" option. So I want it based on the user that is selected in the drop down, in this case - I am working with a timeline. Any suggestions? 

airtable.com/appID/pagID/recID

Thanks!

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

I'll write a response here.

The interface has filter and sort information in the URL but is encoded in BASE64.

https://airtable.com/app~/pag~?DfXMD=b%3AWzAsWyJxUG9RUSIsMTEsImFhYSJdXQ

This URL filters in fields that contain the value "aaa".

When decoded, it is
WzAsWyJxUG9RUSIsMTEsImFhYSJdXQ => [0,["qPoQQ",11,"aaa"]]

"qPoQQ" is FieldID
"11" is Operator
"aaa" is Value

If you understand how this works, you could link to a user-filtered interface page.
It would need to be BASE64 encoded, so it would not be possible to do this with just a formula field.

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

I'll write a response here.

The interface has filter and sort information in the URL but is encoded in BASE64.

https://airtable.com/app~/pag~?DfXMD=b%3AWzAsWyJxUG9RUSIsMTEsImFhYSJdXQ

This URL filters in fields that contain the value "aaa".

When decoded, it is
WzAsWyJxUG9RUSIsMTEsImFhYSJdXQ => [0,["qPoQQ",11,"aaa"]]

"qPoQQ" is FieldID
"11" is Operator
"aaa" is Value

If you understand how this works, you could link to a user-filtered interface page.
It would need to be BASE64 encoded, so it would not be possible to do this with just a formula field.

Scott_Gardner1
7 - App Architect
7 - App Architect

Hey Sho- 

 

Any idea how to get a formula for a record detail within a record detail in the interface?

 

CONCATENATE("https://airtable.com/app/pag/" & RECORD_ID())
 
SO I have list, I want the formula to take me to that list in the interface, then to the record detail and then to another record detail within the first record detail - make sense?
 
Basically, switching to the interface, having issues with email automations taking to a specific record detail, since before we could direct right to a view in the data layer base. Thanks for any insight!