How to create condition based on a range?

  • metrocorephone
    Asked on February 15, 2017 at 12:11 PM

    Is there anyway to make a conditional email alert based on a number range. Currently we have vehicle inspection forms that document the mileage and condition of the vehicle. I would like to have an Oil Change email sent out when the mileage entered into the mileage field is between 5000 and 5500. Right now I only see the following states:

    Is Equal To

    Is Not Equal To

    Contains

    Does not Contain

    Starts With

    Doesn't Start With

    Ends With

    Doesn't End With

    Is Empty

    Is Filled

     

     

  • Nik_C
    Replied on February 15, 2017 at 2:21 PM

    You can have "less than" and "greater than" if you use a number field:

    How to create condition based on a range? Image 1 Screenshot 30

    And it will look like this in conditions:

    How to create condition based on a range? Image 2 Screenshot 41

    So you can combine Less than and Greater than to create a range.

    Hope it helps.

    Let us know if we can be of any additional assistance.

    Thank you!