I have a membership database and a View of Local Leaders info, but it is showing each person twice in the View's list. I have tried to delete the contacts and input them back in they still show up double.

  • 1
    Welcome to Stack Exchange! It's not clear what you mean by "show up double". Could you edit your question to include a screenshot so folks can help you better? Thanks! Commented Nov 7, 2018 at 17:50
  • If I type in a name and address it will show double in my Look up Leaders in the CRM. How do you clear it so there will be no double name
    – Robin
    Commented Nov 7, 2018 at 20:30
  • Hi Robin - I'm sorry, but the "Look up Leaders" is specific to your install, so I don't know what you're referring to. A screenshot would be very helpful! Commented Nov 7, 2018 at 20:31
  • Where do I send the screenshot to.................to show what I am talking about in my CiviCRM database.
    – Robin
    Commented Nov 9, 2018 at 16:08
  • You can click "Edit" under your original question and add the screenshot to your question. Commented Nov 9, 2018 at 16:33

2 Answers 2


If I had to guess, I'd say your "Look up Leaders" functionality is built with Views in Drupal or Backdrop, and it shows up double because there are two different "Other" phone numbers for these contacts. It's treating them as two different entries.

If that is the case and if it's possible to remove or relabel the second phone number location type in the contact records (ie. not have two "Other" phone numbers -- although you could have multiple phone numbers if they have different location types) I think it would solve the issue.

EDIT Upon closer inspection, the second "Other" number appears to duplicate the "Mobile" number. In the contact record, try deleting the duplicate number with the "Other" location type.

  • 1
    Worth mentioning that in theory they could experience similar duplicate results for contacts that have multiple emails and addresses.
    – petednz - fuzion
    Commented Nov 12, 2018 at 19:07

If I had to guess - you have duplicate contacts.

I would check out the user guide - https://docs.civicrm.org/user/en/latest/events/online-event-registration/#contact-matching-and-duplicate-management

Go through your contacts and merge duplicates. (Contacts>>>Find and Merge duplicate contacts) Maybe start with a couple to see if that is the source of your issue. This could have happened due to many factors - but most likely because you have a form or created an import and did not select any duplicate matching rules.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.