Filter records based on Array values

1812 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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)?

2 Replies 2

hi @esse,
You could use the Airtable filtered views (link to an Airtable article about them: Then as filter you could add a condition filtering out the records where the specific array field contains the relevant combination of characters


4 - Data Explorer
4 - Data Explorer

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