Checkbox doesn't work, reverts to 'checked'

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
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.
Photo of David

David

  • 598 Points 500 badge 2x thumb

Posted 1 year ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,436 Points 50k badge 2x thumb
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.
Photo of David

David

  • 598 Points 500 badge 2x thumb
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?)

Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

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

David

  • 598 Points 500 badge 2x thumb
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.