How to know what text options are selected when adding fields in calculation?

Hello,

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...

RED
BLUE
GREEN
WHITE

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 :-)

Thanks

Noemi

Hi Noemi,

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. 

Thank you!

Hi Welvin,

I set up the check box properties as you said...

Name: CHKB1
Options: RED, GREEN, BLUE, BLACK
Calculation Values: R, G, B, BL

Then I inserted a calculation form, that includes formula
CHKB1
only.
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?

Thanks again

Noemi

Hi again,

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. :-)

Sorry :-)

Friendly

Noemi

Hi Noemi,

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!

Hi Welvin,

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:

Options:

RED
GREEN
BLACK

Values:

R
G
B

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  :-)

Noemi

Szia Noemi,

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.

Smart Forms Using Conditional Logic

How to Insert Text or Mathematical Caculation into a field using a Condition

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.

Best Regards,
Ben