JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Form Calculation Widget and Conditions optionsAsked by jpmirza on March 09, 2014 at 07:25 PMHow to incorporate Logic in a field 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??
EditJotForm SupportAnswered by EltonCris on March 09, 2014 at 01:46 AM
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 thanoptions 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 have already responded to you on the following thread: http://www.jotform.com/answers/344089-How-to-incorporate-Logic-in-a-field?entrymessage=10732640770