I have a column with the following specs:
Type = Decimal
Minimum value = 0
Increase/decrease step = 10
Decimal digits = 5
It’s used as part of a number of different tests we want the user to perform. So sometimes the answer will be 0.33411 and others times 43. The user wants it to increment in steps of ten so the later is quicker to do. But if I choose a step value of 10 and the answer is not divisible by 10 then I get “This entry is invalid”. This seems illogical as surely any such validity check should be in the Valid_If formula?
Is this related to below feature request from @Marc_Dillon?
[Number/Decimal column step size should not determine validity](https://community.appsheet.com/t/number-decimal-column-step-size-should-not-determine-validity/19924) Questions
When you have a number or decimal column where you specify an increase/decrease step size, it seems that this causes some internal validity check that any manually entered inputs must be a multiple of the step size. This seems extraneous given that we can already specify our own valid_if expression to cover this if we want, and I see no reason why this should always be forced. Consider a situation where you need to allow decimal inputs to a column, however most of the time the inputs are just i…
@praveen I think you had interpreted this setting as a data constraint, but I suspect most users just expect it to affect how the + and - buttons work. Since we do already mix presentation options in the column settings, maybe we should reinterpret this one?