AnsweredAssumed Answered

How to prevent a duplicate contact?

Question asked by sydbarker on Oct 29, 2015
Latest reply on Oct 29, 2015 by sydbarker

In my contacts database, what I need to do is create a script trigger that once a First Name and Last Name matches an existing contact, the message will pop up "A contact for John Smith with Global Industries already exists. Do you wish to continue?"

What I am having trouble figuring out is how to get it to check all records for John Smith. I know that some people could have the same name, but work for different companies and I am trying to get around requiring a unique value.

Any suggestions on how to do this?

 

Thanks in advance!

Outcomes