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.


  • Profile Image

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

    Asked by Nolasol on November 20, 2014 at 11:52 AM

    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

    check checkbox form calculation Numeric
  • Profile Image
    JotForm Support

    Answered by Welvin on November 20, 2014 at 01:20 PM

    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!

  • Profile Image

    Answered by Nolasol on November 21, 2014 at 06:46 AM

    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

  • Profile Image

    Answered by Nolasol on November 21, 2014 at 07:12 AM

    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

  • Profile Image
    JotForm Support

    Answered by Welvin on November 21, 2014 at 09:08 AM

    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!

  • Profile Image

    Answered by Nolasol on November 21, 2014 at 11:27 AM

    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

  • Profile Image

    Answered by Ben on November 21, 2014 at 01:20 PM

    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