Airtable Search Module - How to find records that match multiple criterias

How To
,
1

Hello Makers,

I am using the search module to get records matching a given criteria. The problem is that the parameters are coming from a multiple select field and often have multiple values such as (S,M,L,XL).

I can create formulas to find individual criterions like {size}=‘S’

But what should I do when I want to find S,M,L at the same time?

The formula I tried: OR({size}=‘S,M,L’

Thanks for your help

2

Hi Please try this formula ,

OR(({size}=‘S’, {size}=‘M’,{size}=‘L’)

2 Likes