Hello Community,
I'm needing more brain power to solve an issue filtering a table view.
Background: I have field technicians submit a log from their field work.
These logs are each pulled into Airtable and have a view that filters to a specific group of questions/answers so that we can use an automation based on how those questions are answered to address any issues.
We recently added some new questions to one of these groups.
I tried updating the filter to include these new questions, and it behaves unexpectedly.
I've attached a screenshot of the filter for the table.
The logic would say that if any of the 4 conditions in the condition group were not empty then the records that match would show up in the view, but that's not what happens.
As it is now with those conditions set like in the screenshot, I'm missing three records.
If I remove the first condition from that grouping (Did a Soiling...), then the missing records are all that show in the view.
That follows the logic, as these three records are the only ones that would have an entry in the three other conditions in the group (ARES...)
What I can't figure out is why, when I add in the other condition back to the group, does it remove the three missing and show all the others.
Thanks in advance for any advice.
