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

    Trying to create a conditions based on number range

    Asked by goSkwerl on July 24, 2017 at 06:39 PM

    Hi, we are trying to make a "change order calculator" for our service.  Based on the the user's inputted "Total Project Budget", we would like to immediately display a preliminary "Peer Review Estimate"

    Unfortunately, when I create the conditions, and say conditions must meet ALL the factors, the form does not behave properly.

    We need the following conditions

    Lowest Highest Peer Review Estimate
    $0 $5,000,000 $3,600
    $5,000,001 $9,999,999 $5,400
    $10,000,000 $19,999,999 $7,200
    $20,000,000 and above $9,000
    Page URL:

  • Profile Image
    JotForm Support

    Answered by EltonCris on July 24, 2017 at 10:51 PM

    In your table, the output would be the 3rd column when the user inputs a number that is between the lowest and highest range on their corresponding row?

    If yes, you can simply create a greater than condition. You can achieve this when you use Number field type as the budget field.

    Example: Make sure they are in the same sequence since conditions on top are prioritized.

    Demo: https://form.jotformpro.com/72048757662970 

    Hope this example helps you!