Can't figure out to make And/Or filters

I have a base of about 1000 material records which is linked to a projects table.
Each records has a color code say:
‘D505223803’ and ‘7F2029’ and a quantity.
I want to be to filter my materials table to search for materials that either both is in stock and has a color code of either ‘D505223803’ or ‘7F2029’…

No matter what I do then it seem not work, any suggestions what I can do about this?

Hi @Kim_Trager1 - Airtable’s filter doesn’t allow for combinations of AND and OR, so I think you are out of luck here.


This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.