Data Validation - Decimal Places

AppSheet AppSheet Q&A
1

I’m working on an app that requires a user to input data from a digital reader that displays a value to 4dp.

Is there a way to create a data validity rule so that if a user enters a value to 2dp (accidentally or otherwise), the error message is displayed and only values entered to 4dp are accepted?

2

The only way I can see it working is if you have that column as a TEXT value. With that you can use this as a Valid_IF

LEN([InputData])=6

LEN doesn’t work with a 4 digit number because as soon as you type “1” that comes up as 6 digits because its going to save it as 1.0000.

Hope this helps a little. This might also be useful - https://help.appsheet.com/en/articles/2435440-mid

Simon@1minManager.com

3

How about LEN(TEXT(NUMBER([InputData]*10000)))=5

4

@Aleksi I think both our ideas suffer from the same failing. The number might be

5.1234
or
5000000000.1234

Maybe we have to do something with Mod() or Round() first ?

5

You could try:

LEN(RIGHT([InputData], LEN([InputData])-FIND(“.”,[InputData]))) = 4

1 Like
6

Oh, my turn!

(LEN(INDEX(SPLIT(([InputData] & ""), "."), 2)) = 4)
2 Likes
7

@1minManager Yeah… we both thought that it would be like 5.1234

1 Like