Currently when you select the “Is Any Of” filter you are not able to filter by the fields that are empty. For example, if I have a single select column called status with values: “To Do”, “Doing”, “Done”. Then I want to show only records with “To Do”, “Doing” and Empty. I cannot do it. I have to choose whether I want to show only empty or anything with value in it.
So if you can just add the option EMPTY in the filters “Is any of” or “is none of” it would be great!
While I can understand your desire to have everything in a single filter choice, this can be done by adding a second filter criteria to include empty fields:
@Justin_Barrett The reason for this request is not desire for more comfort. I can see that it can easily be solved with an OR filter. But what about cases where you have a couple of AND filters set in place already and you cannot use the OR filter after them?
I just gave this simple example in my original post so I can explain the feature request. But the use case scenario is a lot more complicated. There are many cases which lack the empty filter used in combination with “is any of”.
Beside being a convenience it’s also very logical to include the empty value next to other values in the same filter as a selection. Even though it is empty, it is a type of value that can exist in a given column.
Mid '21 and it appears this still hasn’t been considered? “Empty” should be a system option for any select-type fields. Given that airtable doesn’t support nested filtering expressions this is especially limiting.
Not sure why this didn’t occur to me when I posted 2+ years ago, but there is another way around this issue: reverse the logic and use a single element with “is none of” and all of the options that you don’t want.
Here’s an example. I have three options: “Todo”, “Doing”, and “Done”. If I set the filter to “is none of” and “Done” as the only choice, that means that it will leave any records where that field is either empty or contains any of the remaining choices.
