Apex Code Development You need to sign in to do that
Don't have an account?
Zip Code Validation Rule
Hi all!
Trying to make a validation rule on the Lead Object that would throw an error whenever the zip code is not equal to having 5 numbers in it.
Right now I have this:
LEN(Postalcode)<>5
However, this throws an error whenever the zip isn't filled out - I need it to trigger whenever that zip code field is filled out but isn't 5 numbers.
Thanks for any help you can give!
Trying to make a validation rule on the Lead Object that would throw an error whenever the zip code is not equal to having 5 numbers in it.
Right now I have this:
LEN(Postalcode)<>5
However, this throws an error whenever the zip isn't filled out - I need it to trigger whenever that zip code field is filled out but isn't 5 numbers.
Thanks for any help you can give!
All Answers
What about this?
OR(ISBLANK(ZipX__c), LEN(ZipX__c) < 5, LEN(ZipX__c) > 5)
NOT ISBLANK( pin_no__c ),
LEN( pin_no__c )<>5
)
but it shows Error: Incorrect parameter type for function 'LEN()'. Expected Text, received Number what can i do mr scoot