Discussions

Expand all | Collapse all

Checkbox doesn't work, reverts to 'checked'

  • 1.  Checkbox doesn't work, reverts to 'checked'

     
    Posted 07-17-2017 20:24
    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.


  • 2.  RE: Checkbox doesn't work, reverts to 'checked'

    Posted 07-17-2017 20:53
    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.


  • 3.  RE: Checkbox doesn't work, reverts to 'checked'

     
    Posted 07-17-2017 21:06
    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?)



  • 4.  RE: Checkbox doesn't work, reverts to 'checked'

    Posted 07-17-2017 21:56
    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)]


  • 5.  RE: Checkbox doesn't work, reverts to 'checked'

     
    Posted 07-18-2017 12:37
    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.