Help

Re: Interface Filter Element URL

353 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Tristan_Scifo
6 - Interface Innovator
6 - Interface Innovator

I’ve built a client meeting interface for my team with the following elements:

  • Client record dropdown element
  • Meeting record dropdown element
  • Client Goal filter element (to filter for only the goals linked to the meeting)
  • Client Action Item filter element (to filter for only the action items linked to the meeting)

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

12 Replies 12
Harry_Singh
5 - Automation Enthusiast
5 - Automation Enthusiast

I believe [Interface] Use Data to Populate Connected Filter ... - Airtable Community   is a new idea request for this to be implemented. 

einfachiso
5 - Automation Enthusiast
5 - Automation Enthusiast

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. 😃

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!!!