- jpmirzaAsked 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.
- JotForm Supportashwin_dAnswered on March 10, 2014 at 01:59 AM
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