What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
How to know what text options are selected when adding fields in calculation?Asked by Nolasol 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 :-)
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.
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?
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. :-)
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!
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 :-)
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.