Hm I assume you’re talking about a shared view?  For the spaces, we should be able to handle those by replacing the spaces with ‘%20’.  For the non-English characters, Chinese (simplified) works for me, not sure about other languages though?

https://airtable.com/appjL907k1FcVMLQe/shr1XED4Di0ONFVfs?filterEquals_测试=Todo

And here it is unfiltered: https://airtable.com/appjL907k1FcVMLQe/shr1XED4Di0ONFVfs

If you DM me a read-only invite link to your base and tell me what you want the filters to be I can see what I can do!

I was thinking about a shared interface, I do want the users to be able to edit data through the interface.

I want to set values for both filters available in the interface:
1. לקוח

2. סטטוס ביקורת

Sending you a private message with an invite to the base and interface

Thanks for the links!

Ahh, the Interface URL filters are kind of tricky to deal with.  The problem is that the filters are base64 encoded, and so if you want to dynamically create these links you’re going to need to write a script to help with this

If the permutations for this are quite limited, I’d suggest setting those filters yourself and just copying the URLs from the URL bar, way easier than writing a script 

---

Could you talk a bit about your workflow here?  From what I can see ‘לקוח’ appears to be a field that includes user’s emails?  Given that you want them to be able to edit the data, that implies they have Airtable accounts and if so you could filter by the logged in user instead of via the URL

https://support.airtable.com/v1/docs/interface-designer-permissions?highlight=interface#filtering-data-by-current-user

And you can also set a default filter for the checkbox field ‘סטטוס ביקורת’ too so that when users view the Interface they’re only seeing ticked/unticked records:

For the ticked boxes, yes that makes sense.

The flow is that employees click on a link from Zoho CRM, which takes them to Airtable. There the interface should show content relevant only to that customer, therefore the filter and the desire to set it from the URL.

Regarding generating the URL manually, sounds good! I’m still not sure though what URL to use to generate the preset, it is the interface URL or the base URL?

Ahhh, those are customer emails not user emails, yeah then filtering by current user won’t work

---

Regarding generating the URL manually, sounds good! I’m still not sure though what URL to use to generate the preset, it is the interface URL or the base URL?

Ah that’s the Interface URL after you’ve added the filter

For example in this Interface (invite link), the base link is https://airtable.com/app7bQmcRzQSL8FKk/pagM6ivRCRuAIGAis

And here are some filtered URLs:

Linked Record = Test A: https://airtable.com/app7bQmcRzQSL8FKk/pagM6ivRCRuAIGAis?3Fst7=b%3AWzAsWyJUc3pDUyIsNixbInJlY1RKNEVwcVhvUlhVc1lHIl1dXQ
Linked Record = Test B: https://airtable.com/app7bQmcRzQSL8FKk/pagM6ivRCRuAIGAis?3Fst7=b%3AWzAsWyJUc3pDUyIsNixbInJlY0JoNW1CN294a1I4SkZyIl1dXQ

How many customers and how often do new ones get created?  If there’s a lot of customers / additions then you may want to consider getting that script created

Basically everything after the ‘%3A’ is base64 encoded, and once you decode that you’ll see something like this:

[0,["TszCS",6,["recBh5mB7oxkR8JFr"]]

From here you can see that the last part is the record ID, and you’d get your script to replace that record ID with the new customer’s record ID, then base64 encode it and then construct the URL again.  It sounds like a lot but it’s fairly straightforward and some experimentation with ChatGPT will probably get you sorted!

​@Dina 

If you use the Record Review interface (instead of the list interface) — where every record in the left margin represents a different customer — the URL is a very simple one because it doesn’t use any encoding.

You'll notice that the end of the URL ends in “recXXXXXXXXXXXX”. That is where the customer’s Record ID is placed, with no encoding at all.

You can get the Record ID by using this formula: RECORD_ID()

And you can incorporate that into a larger formula that creates the entire URL.

Hope this helps!

If you have a budget and you’d like to hire the best Airtable consultant to help you with this or anything else that is Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld