I would like to not only limit the values in an integer field to positive by using a constraint but would like to limit the spinner to only show/allow positive values. I was able to do this with an input mask for a single digit integer, but need to allow for a two digit integer and 09 as the input mask it allows again for negative values. Any thoughts on if it is possible to limit the spinner to a 2 digit positive integer?
Solved! Go to Solution.
Hi Brent,
The spinner cannot be limited to positive values.
I found a possible solution while investigating calculations using XLSXForm.
Use the formula .>=0 and .<100 in the constraint field. If the user enters a value outside of the range 0-99 the question will be highlighted in red and the form cannot not be submitted - see the screenshots below