Form Calculation Widget and Conditions options

  • Profile Image
    jpmirza
    Asked on March 09, 2014 at 07:25 PM
    How 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??

     

    Page URL:
    http://form.jotform.us/form/40665732866161 

    Numeric 3 then andEdit
    Profile Image
    JotForm Support
    Answered by EltonCris on March 09, 2014 at 01:46 AM

    Hi,

    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!

     

    Hello,

    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.

    Thanks 

  • Profile Image
    ashwin_d
    Answered on March 10, 2014 at 01:59 AM

    Hello jpmirza,

    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

    Thank you!