How to create this Calculation formula

shabir allie
Asked on September 16, 2014 at 04:30 PM

Hi,Can the following conditional logic be carried out :
calculation less than 25 but more than 18 and calculation less than 30 but more than 25....and so on
Thank You In Anticipation

This is a re-post of a comment on Smart Forms: Conditional Logic for Online Forms
Jonathan

Jotform Support

Answered on September 16, 2014 at 04:44 PM

Hi,

I highly recommend that you create a Jotform account first before proceeding. You can use this link to do this. http://www.jotform.com/signup

As to your question, the answer is yes.

This condition is possible X < 25 and X > 18 and X < 30 and X > 25

It should look like this

Hope this help. Inform us if you need further assistance.

Thanks!
seanmccthy
Answered on September 16, 2014 at 04:58 PM

Hi Shabir Allie,

You can carry out logical conditions on numeric fields such as "Number" field found under Quick Tools.

Once you have the field on your form set the conditions for it to trigger an action base on the customer input. On the form, I have 2 conditional statements set to hide the Jotform logo if the user enters a number that is greater than 18 but less than 25 or a number that is greater than 25 but less 30.

You have to ensure that "All" is selected as seen in the picture above for both conditions. If this is not done the statements will not be effective. I hope this helps. I will be here if you need further assistance.

Regards,

seanmccthy
shabiro
Answered on September 16, 2014 at 05:35 PM

Thank You Jonathan

Can i create the more than and less than" functions with the calculated values as well.

Regards

Shabir
Jonathan

Jotform Support

Answered on September 16, 2014 at 05:41 PM

Hi Shabir,

Yes you can also. It will be like this

Please tell us if you need further assistance.

Thanks.
shabiro
Answered on September 16, 2014 at 06:05 PM

Sorry Jonathan

Maybe i am not making myself clear.Let me try again.

Have a look at the template called BMI on jotform website.I need to redirect the different answers to a different "thank you page"

Example: If the answer is more than 18 but less than 25 go to "thank you"page 1

If answer is more than 25 but less than 35 go to "thank you" page2

and so on and so on

I need to use the conditional wizard NOT on the information ENTERED but on the resulting answers.

I hope i have made myself clear enough.

Thank You
Jonathan

Jotform Support

Answered on September 16, 2014 at 06:26 PM

Can you share to us the URL of this template.

I tried looking for it http://www.jotform.com/form-templates/search/BMI but I must be searching the wrong URL.

BUT yes, it will still work even for Calculation results.. test this jotform http://form.jotform.me/form/42586092610454?

Condition is like this

Thanks.
shabir allie
Answered on September 17, 2014 at 12:41 AM

Hi
Herewith the url for the BMI calculator.
http://www.jotform.com/?type=widgets&name=bmi_calculator
Thanks
S.Allie
...
NeilVicente
Answered on September 17, 2014 at 03:53 AM

@shabiro

Unfortunately, widgets with multiple inputs will not play well with conditions, so this will not work.

You can use replace the BMI widget with ordinary fields instead.

Meanwhile, I will send an inquiry to our developers to see if there's anything we can do to make such a widget work with calculations and conditions.
shabir allie
Answered on September 17, 2014 at 09:51 AM

Hi
Thank you for your reply.Imn the meantime i have decided to use the bmi
widget as it is.However can you please check it out as it does not work
anymore.Where the entries for weight and height is the following
appears"One more step please complete...."
Can you please restore the widget please at
http://www.jotform.com/?type=widgets&name=bmi_calculator
Thanks
Shabir
...
Welvin

Jotform Support

Answered on September 17, 2014 at 10:42 AM

Hi Shabir,

Try to use search for it and drag it to your form while you're in the form builder:

Thank you!
shabir allie
Answered on September 17, 2014 at 12:11 PM

Hi
When i do what you say the following happens.It appears there is some
problem on your side.See below.
http://widgets.jotform.com/widget/bmi_calculator
bmi
...
Welvin

Jotform Support

Answered on September 17, 2014 at 12:33 PM

Hi Shabir,

I have decided to moved your problem with the BMI Widget to a new thread, please check it here: http://www.jotform.com/answers/430303. We'll respond to it shortly.

Thank you!
shabir allie
Answered on September 17, 2014 at 02:01 PM

HI
I have been setting up the bmi calculator widget without problem
yesterday.Today it appears that the calculation part is corrupted on
your side.Please let me know when it will be sorted out please.You may
go to the url below to see what i mean .All websites carrying this
widget is showing "One more step" in the height and weight inputs.
http://www.jotform.com/?type=widgets&name=bmi_calculator
Thanking you in anticipation.
...
Welvin

Jotform Support

Answered on September 17, 2014 at 02:36 PM

Hi Shabir,

Please post your reply to this thread: http://www.jotform.com/answers/430303 for the BMI Calculator widget problem. The original post on this thread is unrelated to this issue. We've made it this way so we can focus on each problem and to know which issue is resolved and what not. This is also to avoid confusion.

I will also be posting my reply there, in a moment.

Thank you!

Your name

Your email

Your Answer