Forum Discussion

JoanPlesa's avatar
JoanPlesa
Qrew Member
4 years ago

New QB Report Columns Unable to Filter Multiple Choices

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 s...
reports and charts
JoanPlesa's avatar
JoanPlesa
Qrew Member
4 years ago
I'm not sure if I phrased the wording correctly of my problem.  I have a report.  See below for column names:


In all columns I can filter for multiple choices ie: Provider Status I can click on the filter and choose Active, Inactive and Pending from the drop down and it will show all Providers in those 3 statuses.  However when I click on Provider name it won't show a drop down and will only let me pick one Provider.  I would like to be able to filter for multiple providers.

------------------------------
Joan Plesa
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
4 years ago
Right, so I believe that  did understand your question and what I'm saying is beyond a certain number of choices they do not offer a drop down. So there is no way to get a drop down.
My suggestion was if you know one or two or three provider names that you're looking for you can in fact search on them by name and you can choose multiples by separating the phrases by OR. 

So I was just trying to offer a next best alternative.

If you had some way to have a different report that had fewer different providers then it would offer a drop-down list.

For example if you made a summary report where the user drilled into a summary report and you set the table report as the target perhaps according to where they drilled down in the summary report they would be able to pre-filter the drill down target so that there would be fewer choices.


------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • JoanPlesa's avatar
    JoanPlesa
    Qrew Member
    4 years ago

    OK.  I'm a little slow sometimes.  I just checked another App and the list of Providers is under 100 so does allow you a choice.  I'm guessing that's about the limit.  I guess that's one of the reasons I get frustrated with the new QB.  In the old version you can filter by Provider in the report I was talking about.  It's a bit more laborious but doable.  I'll advise my co-worker who requested the change to switch to old version while running the report as long as it's available.


    Thanks so much for your help and support.  It was driving me crazy that I couldn't figure a way to do it! 


    Thanks again!


    Joan