I am trying to create a validation rule on a Text Encrypted field that allows only numeric values but also allows for blanks. I've tried a handful of rules and I can't seem to come up with one that allows for blanks. Below is my rule
AND(
ISBLANK(Last4__c),
NOT(ISNUMBER(Last4__c))
)
Thanks in advance for the help.
3 risposte
Hi Jessica, Please try the below
AND(
LEN(Last4__c) > 0,
NOT(ISNUMBER(Last4__c))
)
ISBLANK will not work with Encrypted fields.
the above validation rule will only fire if there is a value in the field and that value is not a number.
