Discussions

Expand all | Collapse all

Can't filter on certain fields

  • 1.  Can't filter on certain fields

    Top
    Contributor
    Posted 07-31-2017 20:55
    I have a numeric field that is is checked to be unique & the searchable box is checked but QB will not set this field as a dynamic filter.  This particular field has a unique number for every project in the app.  There are other fields that QB has created as dynamically filterable except the field they reference is null for a good portion of the projects.

    Thoughts?


  • 2.  RE: Can't filter on certain fields

    Posted 07-31-2017 21:20
    Numeric fields are not eligible as Dynamic Filters.
    But  "no problem".

    Just make a new formula text field and have the formula be 

    ToText([my numeric field that is not allowed as a DF]) 


  • 3.  RE: Can't filter on certain fields

    Top
    Contributor
    Posted 07-31-2017 21:26
    I have to say, a field that is forced to be unique, whether text or numeric, should be the first option to perform dynamic filtering...but that's me living in the ideal world.  Here's another for the Feedback section.

    Thanks for the help.