Formula filter based on record id

[esse]

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

[Alessio_Monino]

hi @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

[esse]

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