You need to sign in to do that
Don't have an account?
Russel Mendoza
Validation rule to accept a 0.00 format
Hi team,
I'm working on a flow on a specific field that will only accept 0.00 format of number. Any number from 0-9 is fine as long as the format is a 3 numbers that has a decimal after first number followed by a 2 numbers format (0.00).
I'm using the code below but it seems like it doesn't work the way I expected it to be:
REGEX(Text({!ACCEL_OPEN_ANGLE}),"\\b\\d{1}[.]\\d{2}$")
Any help is greatly appreciated.
Any help will be appreciated. Thanks.
I'm working on a flow on a specific field that will only accept 0.00 format of number. Any number from 0-9 is fine as long as the format is a 3 numbers that has a decimal after first number followed by a 2 numbers format (0.00).
I'm using the code below but it seems like it doesn't work the way I expected it to be:
REGEX(Text({!ACCEL_OPEN_ANGLE}),"\\b\\d{1}[.]\\d{2}$")
Any help is greatly appreciated.
Any help will be appreciated. Thanks.
Check below screenshot of an example:
And Validation rule would be:
Let us know if that works for you..
Best Regards,
BALAJI
All Answers
Strange way for controlling a numeric value. You can just enclose your formula with NOT ( ) if you want absolutely a regex but that is not the better solution.
ACCEL_OPEN_ANGLE has just a numeric value between 0 and 10 (excluded) with Decimal Places = 2
These formulas are better:
ACCEL_OPEN_ANGLE <= 0 || ACCEL_OPEN_ANGLE>= 10
or
NOT ( ACCEL_OPEN_ANGLE > 0 && ACCEL_OPEN_ANGLE < 10 )
Text(ACCEL_OPEN_ANGLE) of the numeric value 1.00 is equals to "1" thus the regex will never work.
Regards,
Alain
Please try below formua for the format 0.00:
Let us know if that helps you.
Best Regards,
BALAJI
I tried to use the formula you suggested but it seems like it's accepting every numberical value I put in. Like if I put in 5 numerical number it will accept it. I only need the ACCEL_OPEN_ANGLE to accept any number as long as it remains in the format 0.00. Any format aside from that should be invalid. Thanks for the reply.
Regards,
Russel Mendoza
Check below screenshot of an example:
And Validation rule would be:
Let us know if that works for you..
Best Regards,
BALAJI