Sep 28, 2022 08:08 AM
I’ve built a client meeting interface for my team with the following elements:
My objective is to generate an automated URL to view the interface with all 4 elements prefilled.
I’ve been able to prefil the client record and meeting record, since these only use record IDs.
However I can’t seem to identify what data type the filters utilise in their url code.
Here are some examples of one of the filter’s URL code:
0Klo0=b%3AeyJBYk5NTyI6W1swLFsicmVjWEtBdGMzQmJaY0JlaUYiXV1dfQ
0Klo0=b%3AeyJBYk5NTyI6W1swLFsicmVjR1pWRzc1OU50Q2JORDkiXV1dfQ
The bold part appears to be the value of the filtered meeting, but is clearly not a record ID.
If I can identify this value type and source the value, I can then build my desired prefilled URL formula for the interface.
Any insights or suggestions would be greatly appreciated.
T
Mar 01, 2024 07:58 PM
I believe [Interface] Use Data to Populate Connected Filter ... - Airtable Community is a new idea request for this to be implemented.
Mar 05, 2024 07:50 AM
Hey,
i had the same issue and just tried a few things.
The parameter for setting the filter is
b followed by a URL encoded colon (%3A) followed by a Base 64 encoded record that looks like this in my case:
{"lmq2i":[[6,["rec5N7fBUoLjX5wh8"]]]}
In your case (eyJBYk5NTyI6W1swLFsicmVjWEtBdGMzQmJaY0JlaUYiXV1dfQ) it contains this:
{"AbNMO":[[0,["recXKAtc3BbZcBeiF"]]]}
The first element seems to identify the filter (AbNMO), don't know what the integer value indicates but then follows the record ID for the elements selected in the filter.
Hope this helps. 😃
Mar 13, 2024 08:16 PM
It worked!! THANK YOU! First decoded the url after the %3A as described. Then used the script shared here to encode it with the desired recordID filled in. Thank you!!!