Hi Team,
Validation should be triggered if the user enters two consecutive dots in the text field. How can we handle this?
Discussion posts and replies are publicly visible
if( find("..", "123..456"), "ERROR", "OK" )
Thanks it works
In addition to the existing set of validations for decimal values, Throw a validation for values like "3.6.5".on top of this code
if( ri!txt = 0, "", if( or( not( rule!APN_isBlank(stripwith(ri!txt, "1234567890,.")) ), find("..", ri!txt) ), cons!CR_APP_FX_VALIDATION_MESSAGE[4], if( (len(ri!txt) - find(".", ri!txt)) > 9, cons!CR_APP_FX_VALIDATION_MESSAGE[3], if( ri!txt < 3.5, cons!CR_APP_FX_VALIDATION_MESSAGE[1], if( ri!txt > 4, cons!CR_APP_FX_VALIDATION_MESSAGE[2], "" ) ) ) ) )