New QB Report Columns Unable to Filter Multiple Choices

Question

Hello,With the new QB in Reports I see that you can filter for multiple options.  I have one column that only allows one choice although there are 240 members in that column.  I checked and made sure that the Field Properties match with the other columns but still only offered one choice.  Is there anyway to make this a multiple choice filter?------------------------------Joan Plesa------------------------------

MarkShnierYou · Answer

I am not sure without testing what the limit is for the maximum number of choices offered as being able to be selected but above some number it just becomes a free form field that you can type into. Imagine if you had 10,000 choices. Obviously that would be a crazy number so they have to pick some limit.

However in both the filter box or also in any column you can put all or part of your search terms separated by OR in capital letters.

So for example if it was a list of pets you could type in

cats OR dogs OR gerbils

The name of the pet is not case sensitive but the OR must be upper case. And of course you don't need to type the complete word that you're searching as it will get hits on partial phrases.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community