Good gracious....I have a voicemail with a phone number, but no name. In a world where databases work properly, we should be able to input the number and get the related contact (assuming the number is in the system, of course.), right?
You can technically look up some phone numbers but not all. If there is any formatting in the number field, you can't search for that number.
- find a record with a phone number that only has numbers in the field, like this: xxxxxxxxxx
- You can find that record by searching for any of the following formats:
- (xxx) xxx-xxxx
- Result: these will all return the correct record
- Now try looking up any record that has a phone number with some other formatting in it like:
- (xxx) xxx-xxxx or xxx-xxx-xxxx
- Try searching for that record in any of the formats above
- Result: you cannot find the record at all
Expected result: any number saved with any formatting can be looked up with any formatting.
What's the difference between (cut and pasted from previous comment)
I ask because, we can definitely set up data entry procedures to ensure that moving forward numbers are entered in a format that is currently searchable. Further, we might be able to en masse reformat phone numbers currently in the database.
I'm not going to speculate exactly where the breakdown is in the system but if the record is saved as xxxxxxxxxx it can be found. But if there is any formatting in the number, it can't.
We have tons of records in the database that are in many different formatting configurations so changing your methods now won't help much. I'd rather make it easy for a user to search in any configuration.