Skip to main content

One missing piece of functionality is the ability to create advanced filters that utilize a combination of AND and OR filters.


For example, here’s similar functionality from EnjoyHQ.


However, I think Airtable could do this even better and the filtering functionality could be even more powerful if there both individual filters and filter groups (with clear visual indicators between filter groups to better illustrate their relationship.


{Filter Group A



  • Filter A1
    /AND]

  • Filter A2}


pAND]


{Filter Group B



  • Filter B1
    /OR]

  • Filter B2
    /OR]

  • Filter B3}

Agreed, this would be nice built-in feature. My workaround was to make a checkbox field, filter records using one set of criteria and check the box for all the records, then do another set of values and check the box for all records, then filter by where the checkbox is checked.


Alternatively, you could use a formula field and build the complicated AND / OR logic in an IF() statement.

Agreed, this would be nice built-in feature. My workaround was to make a checkbox field, filter records using one set of criteria and check the box for all the records, then do another set of values and check the box for all records, then filter by where the checkbox is checked.


Alternatively, you could use a formula field and build the complicated AND / OR logic in an IF() statement.


Yeah, I’ve had to use various workarounds like you mentioned, but I really dislike adding additional fields or complicated formulas to my databases just for these purposes.

Yeah, I’ve had to use various workarounds like you mentioned, but I really dislike adding additional fields or complicated formulas to my databases just for these purposes.



Same here. Its not an ideal solution but it may work in the interim. Hopefully we’ll get more flexibility in View Filters in the future.

+1 for this. I have been using formulas for more complex filtering, but would be much easier to have it in the filters menu.

Definite +1

+100!

This would be very helpful and it’s strange that we can’t currently do this.

Definite +1

+100!

This would be very helpful and it’s strange that we can’t currently do this.


My current workaround until this functionality is available is to create complicated formulas to basically be pre-filters that I can then apply other filters against. Very inelegant and good luck to anyone else trying to decipher how a given view is filtered.

Reply


Terms & Conditions