Look up PARTIAL names!
Train your staff to do look ups on partial names, not full names. If you're looking up an individual's name, you should only have to type in part of the last name to find the record. The same goes for company names (i.e., organization records). Partial is better than full, because full increases the odds of misspelling, and thus missing finding the record.
My last name has a funky spelling and people unfamiliar with it will often mess up the order of the last three letters. So "lil" becomes "ill." If you type my name as "Trochill" instead of "Trochlil" you'll get a "no records found."
But here's the thing: Most modern systems automatically add a wildcard to the end of any word you type in the search bar. So if you enter "troch" rather than "trochill" you'll get all records that START with "troch." And guess what will be on the list? MY name!
Searching on partial names will help you avoid creating duplicate records ("Oh, you're not in here, I'll have to add you") and will improve your customer service ("Can you spell that again for me?").
![]()
Wes's Wednesday Wisdom Archives
Don’t forget to celebrate!
Don’t forget to celebrate! Truth be told, I’m not a big celebrator. (Maybe it’s because […]
Three thoughts on duplicate records
Three thoughts on duplicate records Duplicate records are a reality in any database of any size, […]
Please don’t do this…
Please don’t do this… I’ve noticed a trend among online retailers that I want to […]
AI is perpetually patient
AI is perpetually patient My friend and colleague Noel Shatananda of fusionSpan was providing me some […]
User adoption is (almost) all that matters…
User adoption is (almost) all that matters… I was speaking with an association recently about their […]
When “overcommunicating” becomes overwhelming
When “overcommunicating” becomes overwhelming There is a common belief in project management and general business management that overcommunicating […]
Communicating when there is a major technology change
Communicating when there is a major technology change For those of you who are ASAE […]
Everything works, until it doesn’t.
Everything works, until it doesn’t. “If something cannot go on forever, it will stop.” – […]
Some things are unknowable
Some things are unknowable One of the most challenging aspects of moving to a new […]
Do we have access to that data?
Do we have access to that data? When I work with my clients on a […]
