This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Filters lock to 'And' or 'Or' after the first selection

Showing results for 
Search instead for 
Did you mean: 
8 - Airtable Astronomer
8 - Airtable Astronomer

I want to make a view where I can say:

Product Status is In Stock


Product Status is Backordered


Last Sold Date

was within the last week

However, the filter menu locks to ‘And’ or ‘Or’ dependent on your first selection. Is there any chance you would revise this?

7 - App Architect
7 - App Architect

Hello Matt, the reason we don’t allow combining AND and OR operators in the filter menu directly is that the order of precedence between the operators would be indeterminate without parenthesis. In other words, it would be ambiguous whether you meant (Condition 1 AND Condition 2) OR Condition 3, vs Condition 1 AND (Condition 2 OR Condition 3).

However, a workaround is to create a Formula column, and then reference it in your filter. For example, you could create a Formula column with the formula: "AND({Food color}=green, OR({Food Type}=“eggs”, {Food Type}=“ham))”. Then the output of the formula would be either 1 or 0, and you could filter on this value. Here’s some more info about formulas:

Hope that helps!

5 - Automation Enthusiast
5 - Automation Enthusiast

Is it possible to allow parentheses to be placed in the filter menu / find some intuitive UI of allowing this? Making a new formula can be inconvenient, especially if you have to stack it with error checking as well…