I have a filter question. I am trying to only filter records that has one or more fields that are empty, I am also connecting the individual fields with OR condition. That filter worked, but the filter is also including records that has all empty fields, except for the key field, which I don’t want to show. I don’t understand why.
I have also created a separate filter, in the same database, to show all records that has empty fields, except the key field and the fields in the filter are connected by AND option. This filter is showing only records with empty fields, except the key field, which is how I want the filter to show, so this filter is working.
I don’t understand why the two filters in the same base are showing different results.
I have created a share link to a copy of the database, if anyone wants to take a look. The two filters are:
- ONE OR MORE EMPTY FIELDS (UPDATE) **This is the view that I am having issues with.
- EMPTY FIELDS (NEW)