I am using a encrypted Text Field. List of rules needed:
- Must be able to save a record if value is blank
- Must be Numbers
- Minimum of 10 Digits
- Max of 12 - (implemented with length setting)
What I have Currently 1st Rule:
LEN( Bank_Account_Number__c ) < 10
NOT( OR( ISBLANK(Bank_Account_Number__c ), ISNUMBER( Bank_Account_Number__c ) ) )
How do I format the first rule so that it allows it to be blank also? Or how do I combine them all into one rule?
Bonus Question: Click in field and can't see old data. Type new info in to replace.(cant delete 3 characters and replace) Have to replace entire string.
Thank you for any assistance!