Looking for checkbox for potential duplicates
Have a table of contacts (individuals) with roughly 200,000 records. For a national organization. We want people to be able to enter new individuals with similar names because there may be multiple pe...
Forum Discussion
Here is an idea. (Not perfect, but might help you narrow the list)
Export the entire list to excel with the: Record ID# and Email.
Use the excel function to "remove duplicates" based on the email.
Then create a new column called [Unique Email Checkbox].
After you have removed all of the duplicates, put the value of 1 in the new column.
Then Import those records back with just the RID and a new checkbox field. All your unique emails will have a checkbox checked.
....
If you do this for phone numbers and possibly full names, you could get a pretty narrow list of contacts, that don't have any checkboxes check. Now you know those are most likely duplicates, or not good information to begin with.
Export the entire list to excel with the: Record ID# and Email.
Use the excel function to "remove duplicates" based on the email.
Then create a new column called [Unique Email Checkbox].
After you have removed all of the duplicates, put the value of 1 in the new column.
Then Import those records back with just the RID and a new checkbox field. All your unique emails will have a checkbox checked.
....
If you do this for phone numbers and possibly full names, you could get a pretty narrow list of contacts, that don't have any checkboxes check. Now you know those are most likely duplicates, or not good information to begin with.
- Ideally at the end of this you make the 'email' field be unique for all future contacts, and avoid having to consolidate.
