A few months ago, I shared a validation rule for Contacts to prevent sending emails with “Dear John L.”
My data quality check ensured that users didn’t enter a middle name in the first name field.
But, when I was doing some updates with the Excel Connector yesterday, I realized that my validation rule had a glitch.
It was correctly preventing middle names in the first name field, but it was also throwing the same error when they entered a name that happened to be abbreviated (such as “A. R.”). Or in this case, I was getting the error when I attempted to update the records en masse.
So, I’ve updated my rule to allow abbreviated first names by adding a function to my formula to cause it to fire only when the length of the field is greater than 5 characters.
This accounts for names where a space exists between the acronym or vice versa.
Here is the original error condition formula:
And here’s the updated one:
If you have a more effective way to accomplish this, please do share in the comments!
Facebook: Rather Geeky Tips