Forum Discussion

ArchiveUser's avatar
ArchiveUser
Qrew Captain
8 years ago

Can't filter on certain fields

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 Replies

  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    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]) 
  • ArchiveUser's avatar
    ArchiveUser
    Qrew Captain
    8 years ago
    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.