Is there a way to prevent a value in a number field from being greater than another number field?

  • ZTEXConstruction
    Asked on August 31, 2017 at 1:20 PM

    I have a form with three fields. One labeled "Beginning Mileage", a second called "Ending Mileage", and a final one called "Distance". I currently have a condition set on "Distance", that calculates the difference between Beginning and Ending Mileage. I want prevent anyone from entering a Ending Mileage that is greater than the Beginning Mileage, what would be the easiest way to accomplish this?

    Jotform Thread 1237217 Screenshot
  • aubreybourke
    Replied on August 31, 2017 at 2:39 PM

    Yes its possible. You can try using a calculation condition to test if the start is greater than the end. And if it is change it to zero

    Is there a way to prevent a value in a number field from being greater than another number field? Image 1 Screenshot 20

  • ZTEXConstruction
    Replied on August 31, 2017 at 3:18 PM

    Is there any way to set the field to empty, instead of 0?

     

  • aubreybourke
    Replied on August 31, 2017 at 3:44 PM

    Please delete the previous condition (or disable it). And then try this condition:

    Is there a way to prevent a value in a number field from being greater than another number field? Image 1 Screenshot 20

    The blank space is where you press the spacebar x1 and hit enter. 

  • ZTEXConstruction
    Replied on August 31, 2017 at 4:22 PM

    This works perfectly for me. Thank you!