Please add the ability to set maximum and minimum values of columns of the types Number, Decimal, etc using formulas. It is that different rows may have different limitations. And, although the problem can be partially solved by using the percentage over the variable maximum instead of the value itself, it is important to be able to enter the absolute value, for example, using the Range display mode, within the variable and insurmountable limits, without having to go to the annoying Data Validation messages.Thank you.
To what does this refer?
I mean the following awkward situation. I want to put a variable upper bound to a number entered using Range display mode. But since I can’t make it variable, I set a much higher fixed value. In order not to exceed the desired variable limit, I take advantage of the possibility of using expressions in the Data Validation option, so the system does not allow me to enter a value that is too large and warns me. But then the introduction is done by trial and error, adjusting the slider several times. On the other hand, if the Maximum and Minimum Values could be expressed with formulas, the slider would always move within the limits, without the need to validate data.
Yah, this is a legit request. It took me a while to understand exactly what you were saying though. So here are some screenshots to better show the point:
The config for [number] column, and its valid_if that gives dynamic range under a few different cases. Notice that the Maximum value is set to handle ranges in ALL possible cases.
As you can see, the valid_if restricts the valid range of the input, to a smaller range than the entered min/max, which is very much NOT user-friendly.
The request here is simply that these 2 settings can have expression inputs:
Exactly, Marc. Imagine a warehouse with merchandise that is shipped out. Each item is delivered in a quantity that must not exceed the stock and must be multiple to the number of units in a package. In addition, the minimum quantity dispatched must be equal to that of a package. So I modify my request. The three things: Minimum Value, Maximum Value and the Increase/Decrease Step should be expressed with formulas.
Please excuse my English which is not my language.
Hello people, I also humbly ask for your votes in favor of the proposed change to all those who touched the “heart”. Thanks