- NolasolAsked on November 20, 2014 at 11:52 AM
I have check boxes on my form, all of them includes more options.
Later, in other cells I need to 'know' an item is selected or unselected by user.
I can't use numeric value method, because it is a summary if more options are selected.
For example, I have a check box with items...
User can select multiple items, but I need to know in another field, the GREEN is selected or not.
How can I do it?
If I'd give numeric value (1,2,3,4) and user selects only GREEN, then there isn't any trouble, I see the value is 3, so GREEN is selected. But if the user selects GREEN and RED together, the value will be 4 and I don't know is the selection GREEN and RED or simple WHITE...
I need an >IS_CHECKED(CHECKBOX,"GREEN")< -like function... :-) or a "=" sign in form calculation (then I would make a calculation using formula: (CHECKBOX="GREEN") and the result would be 1 or 0...
I need your help again :-)
- JotForm SupportWelvinAnswered on November 20, 2014 at 01:20 PM
How about adding a Calculation Values to the Checkbox Items?
Or, in the Calculation Result, you can "Add field to equation as text by default":
Did you try this? If not, give it a go and let us know your feedback.
- NolasolAnswered on November 21, 2014 at 06:46 AM
I set up the check box properties as you said...
Options: RED, GREEN, BLUE, BLACK
Calculation Values: R, G, B, BL
Then I inserted a calculation form, that includes formula
The result always is zero, if I select or deselect any options in the check box field...
Maybe I didn't understand something well, please help me, how can I get the result "BL" for example, if I select BLACK option or get a result RG if I select both RED and GREEN options together?
- NolasolAnswered on November 21, 2014 at 07:12 AM
I found what is the solution...
If I select the field CHKB1 in Calculation Form first and then 'Add field to equation as text by default', then the result will be always 0.
If I select first the 'Add field to equation as text by default' first and then I add the field for calculation, then result will be OK. :-)
- JotForm SupportWelvinAnswered on November 21, 2014 at 09:08 AM
I'm glad that you have identified and corrected the problem. If you need further help, just please let me know through this thread or by creating a new post.
Thank you for using Jotform!
- NolasolAnswered on November 21, 2014 at 11:27 AM
I'm here again :-)
I'm working on my form and I see I can't solve my problem anymore :-))
Here is the check box, you know:
Later, in another cell, I would like to know is GREEN ckecked or not.
How can I do it?
If user check GREEN and BLACK, I'll get result in a calculation as "G,B" and how can I see "G" is the part of the result?
I hope I'm understandable :-))
I need an option to see or make reference "is GREEN checked" or not (or any other option, independently of multi- or simple selection).
Thanks again :-)
- BenAnswered on November 21, 2014 at 01:20 PM
You can not do that through the Form Calculation widget, but you can over the Conditions.
If you go to conditions and make a check on the field if green is selected, you will be able to capture this even if all other values are selected as well and then update the field of your choice.
There is a difference in Form Calculation and Conditions, such as this one, but when you utilize both, you will be able to accomplish what you want on your jotform.
Do let us know if you have any further questions.