Hello, is it possible to filter records based on info I have in an array (a series of 5digits codes, comma separated) to show only records having a matching 5digits code (Single Select within a specific column)?
+11hi @esse,
You could use the Airtable filtered views (link to an Airtable article about them: https://support.airtable.com/docs/filtering-records-using-conditions). Then as filter you could add a condition filtering out the records where the specific array field contains the relevant combination of characters
Website: alessiomonino.com
Calendly: https://alessiomonino.com/contact
Email: alessio.monino@gmail.com
+1Hi Alessio, thank you for your reply.
Actually my problem is how to do the query/filter the other way around.
In a scenario where I have one known value, I can easily filter to show records with a cell contaaining many values. So ONE TO MANY ...it works.
My problem is I am trying to filter the other way around.
I have MANY options, and I want to filter cell (Single Select) to show me the match.
So basically MANY TO ONE doesn't seem to work in my case.
Reply
Most helpful members this week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.