Forum Discussion

DavidJung's avatar
DavidJung
Qrew Assistant Captain
8 years ago

Checkbox doesn't work, reverts to 'checked'

I want a user to check-off the attributes they want to generate a report of everything that matches.  I have checkbox fields for the attributes. I set up a report with a filter:

"Field" equal to <ask the user>

I save the report and <ask the user> gets changed to 'checked' and I get everything.

Am I trying to do something I shouldn't, even tho it gives me that choice? At first I thought it was breaking on me because I wanted to do this on more than one checkbox field, but even with just one it does this. Sigh.
Ask about Quickbase functionality
reports and charts
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    For an <ask the user> report, you cannot do an <ask the user> on a checkbox field.

    I could not even build a report that would do that, so I'm not sure how you managed that.  You will need to have text multiple choice fields and then you can do and <ask the user> and the use will answer with a drop down of Yes/ No choices.
  • DavidJung's avatar
    DavidJung
    Qrew Assistant Captain
    8 years ago
    I'm just doing a standard table report and choosing to 'ask the user' as shown below. 

    (I don't know about 'ask the user' as a report type. Is this a thing?)

  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    Right, so there is no such thing as <ask the user> on a checkbox field.  That drop down choice is being mistakenly offered to you and it does not work.  Technically is a bug.

    If you do want to do that type of <ask the user> report, you will need to have a set of mirror fields, one for each checkbox field which calculates to Y or N.

    The the report will need to filter where [DL apps (answer Y or N)] Contains <ask the user>

    I suggest a contains test as you don't know if the user will type Y or y.  I also suggest that you make the field name have the explanation to the user as to what the valid choices are, hence the suggestion

    [DL apps (answer Y or N)]
  • DavidJung's avatar
    DavidJung
    Qrew Assistant Captain
    8 years ago
    A simple little bug, right there in the open, waiting to trip me up. Dang. Thanks for letting me know at least I'm not crazy Mark.

    I have switched to a multi-text field and then offer the users a filter on the multi-choice field on the report. The real challenge was finding a way to create a user-selectable "OR" report method, I like this way, they can see the results.