Can't filter on certain fields

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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?
Photo of Neil Shepard

Neil Shepard

  • 1,248 Points 1k badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,296 Points 50k badge 2x thumb
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]) 
Photo of Neil Shepard

Neil Shepard

  • 1,248 Points 1k badge 2x thumb
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.