Nov 15, 2023 11:18 AM
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!
Solved! Go to Solution.
Nov 15, 2023 04:24 PM
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.
Nov 15, 2023 04:24 PM
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.
Dec 21, 2023 04:33 PM
Hey Sho-
Any idea how to get a formula for a record detail within a record detail in the interface?