Forum Discussion

AidonOlligschla's avatar
AidonOlligschla
Qrew Cadet
6 months ago

Report Settings - Filtering Many of the Same Field

Good Morning,

I hope everyone had a great Thanksgiving!  Wondering if anyone off the top of their head can answer my question regarding filters in the report settings. 

In this case, I am filtering out multiple values for one field;  is it possible to easily combine all of these values into one single filter or do I have to continue to list them repeatedly one by one?  I could have swore there was some way to string this together in the box using <> or something similar.  Screenshot for reference.



------------------------------
Aidon Olligschlager |
Flight Operations Technical Support
Pentastar Aviation
Waterford MI
aolligschlager@pentastaraviation.com | 248-202-9587
------------------------------

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    6 months ago

    If you are willing to hand type you can use the setup "Does not Contain" and then separate the values with OR in upper case.

    So

    Requestor does not contain checkride OR training OR standby

    I suggest not going too wide on one line as you want be able to easily read the filters, so then start a new filter row when it gets too wide.



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------

    • AidonOlligschla's avatar
      AidonOlligschla
      Qrew Cadet
      6 months ago

      THANK YOU, MARK!  I knew there was some kind of simple solution.

      Best,



      ------------------------------
      Aidon Olligschlager |
      Flight Operations Technical Support
      Pentastar Aviation
      Waterford MI
      aolligschlager@pentastaraviation.com | 248-202-9587
      ------------------------------