Any OOTB Edit Validate Rule to Validate Trillion

General
, ,
1

Hi All,

I have a requirement i need to allow one Integer Property value till 2 Trillion by using EDIT VALIDATE

Thanks in Advance

Srinivas

2

@SrinivasaR8416

I don’t think there’s any OOTB rule available as such.

3

Hi @SrinivasaR8416,

I don’t think it will be possible to store such a big value in a integer as the range of integer is around -2147483648 to 2147483647. While the value you are trying validate is greater than 2000000000000.

It better to create a double property here as it can store massive numbers and write your own edit validate.

Something like this -

Edit Validate.png
Edit Validate.png726×507 70.1 KB

Or you can cleverly avoid all this by asking user to enter number in higher denomination like “Please enter number in millions”. This is what we generally use in our project with dealing with higher numbers.

Hope it helps.

Thanks, Ankit

4

@im-ankit

Hi ankit ,

Yes if i change the property type from Integer to Double issue resolved.

Thanks,

Srinivas

5

@SrinivasaR8416

Instead of integer, you can use property type as double.