conditional logic using the "form calculation" or "calculation wizard" widget

  • narrowbridgecandles
    Asked on August 19, 2016 at 12:54 AM

    Hello, I am trying to create a form in which customers say how many of a product they would like and where on a sliding scale they would like to pay for it.

    So far I am just using a text box to gather this information but realizing that if the customer wrote "ONE" instead of "1" all of the calculations and total generation will be thrown off. Is there a type of field that will only accept numerical responses? 

    Is there a way to restrict the numeric responses accepted (for example if the sliding scale is $10-$20 and way to require that the numeric value entered is at least $10?)

     

    Also, I am trying to integrate an appropriate widget and learn how to use it. I need some that can generate a total live in the form from a number of different fields.

    6 pairs of fields in which someone has said they want ______ # of something and want to pay _____ amount for it.

    and then the calculator adds up those totals. I figured out how to do this with the calculation wizard, but can't figure out how to use the for calculation widget- do you have any instructions on that?

    The reason I am exploring both is that I am trying to figure if one of these widgets can add up all of those tallies and then add $5 to each person's total for shipping if they have ordered any of 5 out of the 6 products and $15 for shipping if their order includes one of the products (a very large heavy one).

    I also want these calculations to be included in the automatic reply e-mail.

    I want them to submit the form and then get an e-mail that says:

    THanks so much for your order

    Order Summary (taken from the fields in the form)

    1 ___

    3 _____

    2___

    You total including shipping is _______ (taken from calculator in the form)

     

    Any guidance you can offer would be very helpful, thanks so much

    Jonah

     

  • Rose
    Replied on August 19, 2016 at 4:34 AM

    I cloned your form and worked on it a little bit and found a solution  as following to prevent entering word instead number.

    If you use number field instead of text box, you can prevent to be entered as word version of  a number.

     

     conditional logic using the form calculation or calculation wizard widget Image 1 Screenshot 70



    In addition to that; to ensure that number is entered between specified scale; you need to create conditions according to the following situation.

    If user enters a value out of scale, a warning message appear and the rest of the form including submit button disappear. 

    Here is the condition I created for this scenario : 

    conditional logic using the form calculation or calculation wizard widget Image 2 Screenshot 81

    conditional logic using the form calculation or calculation wizard widget Image 3 Screenshot 92

    conditional logic using the form calculation or calculation wizard widget Image 4 Screenshot 103

    conditional logic using the form calculation or calculation wizard widget Image 5 Screenshot 114


    Please do not forget to apply these rules to your other fields related product and their price. 

    Here is the screen shot if your user enters a value out of scale.

    conditional logic using the form calculation or calculation wizard widget Image 6 Screenshot 125

    Regarding your other question, I opened a new thread and it will be answered there. You can follow it from following link. 

    https://www.jotform.com/answers/910509


    If you need any further assistance from our side, please do not hesitate to contact us. We would be glad to help you. 

  • narrowbridgecandles
    Replied on August 19, 2016 at 8:45 PM
    this is very helpful. I understand all of it except for the part that reads
    "please enter the value between the scale"
    how do I add this text to appear when someone enters a value outside the
    scale?
    thanks
    jonah
    ...
  • jonathan
    Replied on August 19, 2016 at 10:35 PM

    Hi Jonah,

    You can test this form https://form.jotform.com/62318082022950 where I put a very basic example using Condition logic.

    Here is the video when I created the form.

    conditional logic using the form calculation or calculation wizard widget Image 1 Screenshot 20

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