Min and Max formula expression for number type

Could AppSheet be upgraded so the Min and Max values of a number (or decimal, percent) allow a formula expression?

3X_6_4_64b051119481d20809b958a8c497e523042283ad.png

In this example, the maximun is set to 5 using a Valid_if expression. But the App still displays the limits (which is 10) instead. Number 7 is invalid but this is not as user friendly as I would like it to be. I need the range itself to to limit to 5

Status Open
4 7 604
7 Comments
Koichi_Tsuji
Gold 4
Gold 4

How is your current set up for min value and max value for that field?

I believe once you set max value to 5, then the range picket wont show more than 5.

Julien
Bronze 5
Bronze 5

I need Maximum value en Minimum value to be expression with a formula instead of just a value.
In the exemple I showed Min = 0 and Max = 10. But the it happens that the maximum changes, this is why I used a Valid_If expression that limits the value to 5 for example.

Koichi_Tsuji
Gold 4
Gold 4

Okey, then i m afraid you need to place a feature request so that we are able to use appsheet expression inside max/min value settings for number type fields.
Until then you may consider not to select “range” type to input value to those field.

Julien
Bronze 5
Bronze 5

Yes, that’s what I’m doing : placing a feature request.
3X_8_5_85ae3468055a749d22425615b10ad19b28e4f531.png

Or should I proceed another way to place a feature request?

Koichi_Tsuji
Gold 4
Gold 4

That’s proper feature request.

Status changed to: Open
Pratyusha
Community Manager
Community Manager
 
Baur
Bronze 3
Bronze 3

+ feature request