Data Validation - Decimal Places

[Smitster]

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?

[1minManager]

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

[Aleksi]

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

[1minManager]

@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 ?

[Bellave_Jayaram]

You could try:

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

[Steve]

Oh, my turn!

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

[Aleksi]

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