Trying to create a conditions based on number range

  • Profile Image
    Asked 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
  • Profile Image
    Answered 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.


    Hope this example helps you!