May 21, 2022 05:29 AM
I am test-driving Airtable and I have set up an Interface. But instead of just being able to search through one column (Names, Last Names etc). I want to find a match anywhere in the record. There is no Search Element only a Record Picker. Any ideas, anything that I missed?
May 21, 2022 11:12 PM
Hi Navarchy, hmm, you could make a formula field that concats all of the values of the fields you want to look up, and then use the filter element on that field?
May 21, 2022 11:30 PM
Thanks for replying. It could be my lack of knowledge of Airtable. But I think that filter is only applicable outside the Interface environment.
May 21, 2022 11:31 PM
Hm, the gif above is an interface set up with a Filter element in it. Here’s a screenshot of the setup
May 22, 2022 08:36 AM
This is a really cool idea :bulb:
May 22, 2022 01:25 PM
I think I made a mistake myself here. I am looking for a database that just shows the Interface to a certain person and allows them to use it for info. After testing it with a second account I noticed a user can still see the full spreadsheet. Which is something I do not want at all.
I was under the impression the interface section was the only thing a person I invited could see.
May 22, 2022 05:42 PM
This is a very common misconception.
If you only need to share info in a particular table, look into shared views. If you need to share selected info across multiple tables (and have budget), look into third party portal services.