How to use calculations

  • 4goodmeasure
    Asked on September 3, 2015 at 1:59 PM

    Hi.  In the conditions field, can I indicate a range?  ie; If the field is "equal to"  0 through 1000, than it is 100 ($100), 1001-1500 is 200, and so on. 

     

     

     

  • victor
    Replied on September 3, 2015 at 4:15 PM

    Hi,

    This is possible having multiple conditions.

    How to use calculations Image 1 Screenshot 20

    I have create a small form for you to look at and analyze it. You may clone it if you like.

    http://www.jotformpro.com/form/52455835291965

    Regards

    Victor M Larrea

  • 4goodmeasure
    Replied on September 3, 2015 at 9:45 PM
    Thank you SO much! Going to give it a try.

    ...
  • 4goodmeasure
    Replied on September 3, 2015 at 10:45 PM
    Hi Victor, me again. So I was able to make the form as you suggested (thanks!), but I didn’t previously mention that I need to make three of these fields, which is easy enough to do, but I then need the form to add them together using the “form calculation” widget. The values don’t seem to translate when I try to send the output to the calculation field. Any ideas?

    ...
  • BJoanna
    Replied on September 4, 2015 at 4:20 AM

    Is this the form you are working on http://www.jotform.us/form/52458490725159?

    If I understood you correctly you want to pass values from fields "Size of Home" and "Age of Home" based on conditions that you have set to fields "Age" and "Size" and then calculate values form fields Age and Size.

    I have cloned your form and made some changes on my cloned form. This is my cloned form: http://form.jotformpro.com/form/52461857442964?

    Please test it and see if that is what you want to achieve. 

    On my cloned form I have changed this condition, because it is not valid condition. 

    How to use calculations Image 1 Screenshot 20

    Also I have removed calculation form fields "Age" and "Size".

    Feel free to clone my form to your account. 

    Hope this will help. Let us know if you need further assistance. 

  • 4goodmeasure
    Replied on September 4, 2015 at 9:45 AM
    Thank you once again. Yes that is the form I’m working on, however I only added the second set of “size” & “age”, as a possible work around because I couldn’t get it to work. I really only want to have “size of home” & “age of home” (should show the user what they entered in those fields, not the resulting value). Then add those together (using the assigned dollar values) to show in the results field. If I actually need the second “size”, “age” fields, I was thinking I could “hide” them to the user. Do I need them?

    ...
  • BJoanna
    Replied on September 4, 2015 at 11:23 AM

    You can use hide field option inside of Form Builder to hide those fields. Then they will not be visible for your users. 

    How to use calculations Image 1 Screenshot 20

    If you want to have payment field inside of your form, you can pass value from calculation field to payment field. Inside of this guide you can find how to do it: https://www.jotform.com/help/275-How-to-pass-a-calculation-to-a-payment-field 

    Inside of this article you can find out how create payment form:

    https://www.jotform.com/help/47-Order-Form-Basics 

    http://www.jotform.com/help/165-setting-up-your-first-order-form  

    Here is my new demo form: http://form.jotformpro.com/form/52461857442964? 

    Feel free to contact us if you have any other questions.