How can I create a deeper set of filters?

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • In Progress
I'm trying to create a report that is used for auditing and would prefer to have a single view rather than multiple different reports as some records may fail for multiple reasons.  The problem I'm finding is I cannot create a set of filters deep enough.  Basically I have to do the following:

Audited is not checked
AND (
          (Audit criteria 1 AND audit criteria data 1)
         OR
          (Audit Criteria 2 AND (criteria data 1 OR criteria data 2))
        )

I cannot get that last set to indent as you can see below (Arrival and departure are to be OR'd against the after hours being unchecked.


Any suggestions?
Photo of David Berndt

David Berndt

  • 242 Points 100 badge 2x thumb

Posted 3 months ago

  • 0
  • 1
Photo of David Berndt

David Berndt

  • 242 Points 100 badge 2x thumb
Well I found what should have been obvious is to break the Or into 2 different sets.  But if that didn't work are there options or would I have to create some formula field instead?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
Are you sure the report filters don’t work for you. They indent 3 levels deep.


Or like you say. Use a formula field.
(Edited)