How to create this Calculation formula
-
shabir allieAsked 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
-
JonathanAnswered on September 16, 2014 at 04:44 PMJotform Support
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!
-
seanmccthyAnswered 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
-
shabiroAnswered 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
-
JonathanAnswered on September 16, 2014 at 05:41 PMJotform Support
Hi Shabir,
Yes you can also. It will be like this
Please tell us if you need further assistance.
Thanks.
-
shabiroAnswered 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
-
JonathanAnswered on September 16, 2014 at 06:26 PMJotform Support
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 allieAnswered on September 17, 2014 at 12:41 AMHi
Herewith the url for the BMI calculator.
http://www.jotform.com/?type=widgets&name=bmi_calculator
Thanks
S.Allie
... -
NeilVicenteAnswered 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 allieAnswered on September 17, 2014 at 09:51 AMHi
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
... -
WelvinAnswered on September 17, 2014 at 10:42 AMJotform Support
Hi Shabir,
Try to use search for it and drag it to your form while you're in the form builder:
Thank you!
-
WelvinAnswered on September 17, 2014 at 12:33 PMJotform Support
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 allieAnswered on September 17, 2014 at 02:01 PMHI
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.
... -
WelvinAnswered on September 17, 2014 at 02:36 PMJotform Support
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!
-