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

    Multiple calculations using conditional logic and dropdown calculation values

    Asked by dlasson on February 08, 2017 at 11:31 AM

    Hi.

    I would like selections from a drop-down menu to populate two corresponding fields.

    Please see "Insurance Premiums" section at the end of my form.

    Under "Medical Insurance Election" select "EE Only." I would like that selection to populate the "Health Premium" field with that selection's Calculation Value ($125.74). And the same with the other selections. 

    Additionally, I would like "ER Cost of Healthcare" to be populated with an associated value (I didn't know where to record those values) based on what the user selects for "Medical Insurance Election". Let's just use"$300" if "EE Only" is selected, and "$500" if "EE + SP" is selected. So if the user selected "EE Only" for  "Medical Insurance Election" then "$125.74" should appear in the "Health Premium" field, and "$300" should appear in the "ER Cost of Healthcare" field.

    Thanks! 

    Page URL:
    https://form.jotform.com/52805266511149

  • Profile Image
    JotForm Support

    Answered by AIDAN on February 08, 2017 at 12:56 PM

    Hi, thank you for contacting us.

    I have addressed your requests in a cloned form that I created for you here: https://form.jotform.com/70385245222956

    Please feel free to clone it and examine the fields configuration and the conditions required to perform your request.

    If you need further assistance please let us know. We will be happy to help. Thank you.

  • Profile Image

    Answered by dlasson on February 08, 2017 at 02:50 PM

    Thanks so much. I am on the "free" plan and cannot create a new form to see the configuration. Is there another way to see it, or can you please give me the configuration?

  • Profile Image
    JotForm Support

    Answered by AIDAN on February 08, 2017 at 04:00 PM

    You're quite welcome.

    In that case, I will try to detail to you what I did:

    * I replaced your set of conditions with this set:

    * I replaced your "Health Premium" and "ER Cost of Healthcare" fields with form calculation widgets, in case you would like to perform more calculations or just want to have the flexibility that form calculation widgets provide.

    * I added the "Medical Insurance Election" field value to the "Health Premium" field.

    * The conditions above take care of the second case, that we cannot cover with the calculation values as we are using them for the first case. You may add more conditions to cover the remaining dropdown options.

    I can also perform the changes directly on your form if you would like that. All I would need is a reply with a permission from you to do so.

    I hope this helps. Please let us know if you need anything.

  • Profile Image

    Answered by dlasson on February 08, 2017 at 04:25 PM

    Thank you for offering to make the changes! I was able to do them. There is one small issue: the result that shows in "ER Cost of Healthcare" when "EE Only" is selected in "Medical Insurance Election" does not show with a dollar sign. Can you assist?

  • Profile Image
    JotForm Support

    Answered by AIDAN on February 08, 2017 at 04:42 PM

    I examined your form and noticed that this is most likely just a glitch, because when I cloned the form then removed the $ (the dollar sign) in the "EE Only" condition, then added it back again, it worked correctly.

    Please try that and get back to us if the problem persists so we can assist you further. Thank you.

  • Profile Image

    Answered by dlasson on February 09, 2017 at 09:54 AM

    OK, it is working now. Thanks so much!