You need to sign in to do that
Don't have an account?
Siva Sakthi
How to Check the Validation for Fields are Empty or some special character not allowed
Hi,
I have used the text field . I want to add validation for text field below : NOT(REGEX(Address__c , "[a-zA-Z0-9,/.\r\n -]+")). but its working fine only given special character. But we enable the validations means its the mantatory field.
Note : I need to check the condition if text field is empty means it should save. How to do that.
Any one guide me to solve this.
Advance Thanks.
Maheshwar
I have used the text field . I want to add validation for text field below : NOT(REGEX(Address__c , "[a-zA-Z0-9,/.\r\n -]+")). but its working fine only given special character. But we enable the validations means its the mantatory field.
Note : I need to check the condition if text field is empty means it should save. How to do that.
Any one guide me to solve this.
Advance Thanks.
Maheshwar
You could simply add another condition in your validation rule say NOT(ISBLANK(Address__c)) && NOT(REGEX(Address__c , "[a-zA-Z0-9,/.\r\n -]+"))
All Answers
Please refere below link for all kind of validations..
http://regexlib.com/(X(1)A(fQiXWyUt7cjqORiaRTBs7Zm871EiiKGENq-wimimyhI_Igg3t_alkIOAWxWyfVndZQUwXRipDiGFCFCzfhJMEOtyEmwDu1b9uSa6qTdCSz-g1xZxTt9a8dnz-Ifhqj9EnEQfNcS4cCXFRAIfQU9xCDZzO51Zm5BlaVmB45dLeYKBBM58wlwBMKnspPN_fIxX0))/Search.aspx?k=password&AspxAutoDetectCookieSupport=1
Thanks,
Sandeep
You could simply add another condition in your validation rule say NOT(ISBLANK(Address__c)) && NOT(REGEX(Address__c , "[a-zA-Z0-9,/.\r\n -]+"))