Discussions

Expand all | Collapse all

Dynamic Filter on multi select field, And not Or

  • 1.  Dynamic Filter on multi select field, And not Or

    Posted 11 days ago
    When using a multi select field for one of your dynamic filters, it essentially uses an 'Or' function. So, if my field is Colors, and I have 'Red,Orange, Yellow, Green, Blue',  and in my dynamic filter I choose both Red and Orange, it will show me all records that have Red OR Orange Selected.

    Is there some sneaky way to make QB treat this like an And function (presumably with some creative formula field)? So if I select Red, Orange in my dynamic filter, it only shows the records that have Red AND Orange selected?

    ------------------------------
    Michael Tamoush
    ------------------------------


  • 2.  RE: Dynamic Filter on multi select field, And not Or

    Posted 11 days ago
    You can type red AND orange with AND in UPPER case in the search box ......

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------