would like to know how folks handle duplicate phone numbers I realize that Globiflow can help in some cases, but it seems there is a general problem that must exist because there can be multiple phone numbers and multiple phone numbers of the same type (ie: work) so there is possibly a many to many kind of lookup needed.
For example, if an item has two phone numbers entered as type work and one entered as type home, when exporting there will be two numbers in the work column and one in home.
Conversely the same situation would exist if a new item were to be added by import with those same numbers. The import spreadsheet would have the two work numbers separated by a semicolon in the work column.
Questions - For my application I could use text fields and limit users to two or three text fields used for phone numbers. That would simplify the issues, but I'd lose the click to call phone icon. I **think** that I could create a calc field that displays each entered phone number with a hyperlink so that is an option, but it's nicer looking to just use the phone field type. And less wasteful for the more common case of having a single phone number.
Anyway, I hope that someone can share any ideas about how to best handle phone number fields while minimizing the risks of duplicates.
A related goal is to also maintain a method of marking certain phone numbers as dnc (do not call), so the checking for duplicates is even more complicated....
Please sign in to leave a comment.