Hello,
I swear this same question is somewhere on this site but I can't find it. I have an on-prem customer on Forms 11.0.2212.30987. I have a number field that I'd like to enable an answer limit on, but I want the limit to based on another field on the form.
For example, a driver enters their beginning miles on the form, submits the form, and it goes to their inbox for them to add information to throughout the day. At the end of the day, they'll enter their ending miles, and I want to limit this ending miles field to a value that's no more than 800 miles more than their starting miles.
What would be the best way to go about this? Does a more recent version of Forms have this functionality built in? Would a hidden field that calculates this value work in tandem with a field rule work better?
Thanks for the input!
Question
Question
Forms - Number field - Use variable for maximum value
Answer
Version 11.0.2212 was Forms 11 Update 3, which means it's two releases behind the current release of 11.0.2311 which is Forms 11 Update 5.
If they are using the Classic Designer, then the version isn't going to matter, it's going to be the same either way, and it's going to require Javascript.
If they are using the Modern Designer, then I think it might be worth pushing to get upgraded to gain the extra functionality recently added to Field Rules. I could be wrong, and this functionality was already in place on Forms 11 Update 3 (11.0.2212), but I feel like it didn't come until either Forms 11 Update 4 (11.0.2307) or Forms 11 Update 5 (11.0.2311). You can set Field Rules to validate a field above, below, or between specific values or values from other fields. As you mentioned, you would likely still need to include a second (possibly hidden) field to calculate the limit of the start + 800 miles, but that field could be used in the Field Rules to set that limit on the main field. It's a fairly easy, no code solution.