# 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
Answered on August 19, 2016 at 04: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.

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 :

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.

• narrowbridgecandles
Answered on August 19, 2016 at 08: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
Answered 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.

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