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

But filter to help with combining & or filter

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

I know airtable can’t combine & or filters & I can get over it with a formula

is there a reason why there could not be a " but "option

ie xx is ff
& bb is ee
but cc i snot dd

1 Comment
17 - Neptune
17 - Neptune

Yes, and for many reasons. :winking_face:

Boolean math is based on zeros (0) and a ones (1). There is no representation for a tertiary operator.

The following logic embraces the added conditional logic where cc must not equal dd. Ergo, “but” is AND.

if ((xx === ff) && (bb === ee) && (cc != dd))

If by “but” you really mean OR, this works as well. The following logic returns TRUE in two cases, one where cc doesn’t equal dd.

if ((xx === ff) && (bb === ee) || (cc != dd))