You need to sign in to do that
Don't have an account?
mfcain
Phone number restriction
We want to restrict certain phone numbers from being entered in Salesforce. For example, 999-999-9999, to get around validity checking on format, etc. What is recommended for doing this?
You could use a phone verification service like Towerdata or Strikeiron. They verify that the phone number has a valid area code and exchange. I have set that up in our salesforce instance.
So if I wanted to prohibit someone putting in a certain phone number (for example the 999-999-9999), then I'd have to get an application that verifies (or in this case, prevents) the entry of a certain list of numbers...? The Salesforce validation rules wouldn't address this...?
All depends on how many numbers you want to disallow. The way that most people do this is to use a REGEX formula in the validation rule. Something like
OR( LEN( Phone ) = 0,
REGEX(Phone, "[+49]{3}-[1-9]{1}[0-9]{2,3}-[0-9]{3,9}") ,
REGEX(Phone, "[+49]{3}-[1-9]{1}[0-9]{2,3}-[0-9]{3,9}-[0-9]{1,9}"))))
will do it but it all depends on what part of the world you are in and the outputs you want. I got the above by googling "salesforce regex phone"