# So I've got a decimal type column, which 2 de...

(Marc Dillon) #1

So I’ve got a decimal type column, which 2 decimal places specified. I then set the valid_if field to be greater or equal to zero, and a message to display if not “Enter only positive values”. That’s all good.

But then I went and set a step size of 1, thinking that it would make using the + and - buttons easier, depending on what the user entered. I would also expect it to simply add or subtract 1 from any decimal number entered. However this made appsheet think that any numbers with decimals were not valid, and also displayed the same message as described above, even though the entered decimal values were positive.

Is this how it is supposed to behave? I would definitely prefer it to behave like I was expecting.

(Michael) #2

I think I ran into this before as well and the solution was to enter 0.1 as the step value…

(Marc Dillon) #3

Yah, that allows the use of the first decimal place, but then trying to use the 2nd decimal place becomes invalid.

(Michael) #4

@Marc_Dillon Okay well, what happens if you used 0.01 as the step instead of 0.1?

(Marc Dillon) #5

Then the + and - buttons are basically useless, it takes less time for the user to open the keyboard and input their value. I want the buttons to increase and decrease by 1 for those times when the user only needs to input a whole integer.

(Michael) #6

@Marc_Dillon I couldn’t agree more but, that’s what we’re working with. Maybe @praveen or @Philip_Garrett_Appshcould shed some light here?..

(Levent KULAÇOĞLU) #7

@Marc_Dillon to increase a decimal type value by steps, you should use 1.00

(Marc Dillon) #8

@Levent_KULACOGLU That is not correct. Appsheet just changes the step value back from 1.00 to 1, and it works the same.

(Michael) #9

@Marc_Dillon To clarify, ‘it works the same’ you mean, after specifying the step as 1.00 and then entering for example 0.01 in the form, AppSheet says 0.01 is invalid?

(Marc Dillon) #10

Yes, entering 1.00 as the step value works the same as entering 1, with any decimal number entered being invalid.