What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.
We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.
How to add Greater than and Less than condition for Form Calculation widget?Asked by jpmirza on March 08, 2014 at 09:16 PM
I want to know how to incorporate simple logic in a field. For example, the variable A can have numeric values ranging from $ 0 - $ 70,000. Variable B can only have 3 output: PASS, FAIL and POSSIBLE
If A < $34,000, then B = FAIL
If A > $50,000, then B = PASS
ELSE B = POSSIBLE
Can you please advise me how I can acheive the outputs for B based on numeric values in A??
That's possible. First, you have to use Number Tool instead of standard Textboxes and create all 3 text results e.g. Pass, Fail and Possible. Check this visual guide:
Create the conditions afterwards. Number Tool has less than & greater than options when you create condition on the Conditions Wizard. See this image:
Hope this helps!
Thanks of the ideas. They were very helpful. Now, I am 1 step away from completing the form.
Form Link: http://form.jotform.us/form/40665732866161
I am using a "Form calculation" widget to calculate the output for field "Projected NP". The problem is that "Form Calculation" is NOT providing Greater than OR Less than option.
The number option you mentioed above does NOT allow me to put a forumula.
I am basing the output in Projected NP for conditions such as "PASS", "FAIL" or "POSSIBLE"
Please advise how to handle this problem.
I'm sorry for the trouble caused to you.
Unfortunately, our "Form Calculation" widget is does not have the "Greater than or Less than" options. They are currently available in only number fields.
"Form Calculation" widget is a fairly new widget and a lot of feature is yet to be released. This widget is also a numeric field and should have the "Greater than or Less than" options in conditions. I am sending a feature request to our back end team. We will get back to us if we have any update form them.
Man, it is really frustrating how many times I have searched and found the exact answer to a question I have to then click on the see example "here" link to just be redirected to a blank page where the users has deleted the form. Why publish support articles if the actual support is not left intact? Why not create a back up of the from for all to use in the future? Drives me freakin crazy. This is maybe the 5th time that happens tonight.
Our apologies @depotlawncare. For everyone on this thread, here's a working demo and a screenshot.
Thank you for your solutions above. I use it in my form but not everythink works:
The objectif of my form is evaluate the language level and select those who has a too low level, good level and too high level.
and there are few conditions :
1. Choose 1 of the 4 texts
2. Ticks your competences (Number of the ticks counts already of the result)
3. Matrix questions ( the number of "oui" anwsers counts for the final result)
Firstly I have puted form calculation linked to each question (done and working)
Than, in GOOD LEVEL I want to put the result for the people who has a good level (I have used greater than / less than) and it worked.
and I have tried to do the same for NOT GOOD LEVEL and it doesnt work! do you have any ideas why?
Thank you in advance foryour help
Since this is an old thread I moved your question to new one, here is the link.
Please open new threads for your questions so we are able to handle all problems accordingly.