-
ZTEXConstructionAsked 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?
-
aubreybourkeReplied 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
-
ZTEXConstructionReplied on August 31, 2017 at 3:18 PM
Is there any way to set the field to empty, instead of 0?
-
aubreybourkeReplied on August 31, 2017 at 3:44 PM
Please delete the previous condition (or disable it). And then try this condition:
The blank space is where you press the spacebar x1 and hit enter.
-
ZTEXConstructionReplied on August 31, 2017 at 4:22 PM
This works perfectly for me. Thank you!