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.


  • Profile Image

    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??

     

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

    less than greater than
  • 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 than options when you create condition on the Conditions Wizard. See this image:

    Hope this helps!

  • Profile Image

    Answered by jpmirza on March 09, 2014 at 07:23 PM

    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
    JotForm Support

    Answered by ashwin_d on March 10, 2014 at 01:56 AM

    Hello jpmirza,

    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.

    Thank you!

  • Profile Image

    Answered by depotlawncare on July 01, 2015 at 11:29 PM

    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.  

  • Profile Image
    JotForm Support

    Answered by EltonCris on July 02, 2015 at 01:01 AM

    Our apologies @depotlawncare. For everyone on this thread, here's a working demo and a screenshot.

    Screenshot:

    Demo: http://form.jotformpro.com/form/51821054486960?

  • Profile Image

    Answered by Communicaid on March 14, 2016 at 06:43 AM

    Hi,

    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?

    https://form.jotform.com/60732718337963

    https://eu.jotform.com//?formID=60732718337963

    Thank you in advance foryour help

  • Profile Image
    JotForm Support

    Answered by Nik_C on March 14, 2016 at 08:33 AM

    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.

    Thank you.