Set emails to UNIQUE

[drychly]

Hi, is it possible to set the email address field for Users and Contacts as UNIQUE in EspoCRM to prevent duplicates? If so, how can this be configured?

[lazovic]

Hi drychly,

You can either configure the fields for duplicate check in the Contact and User entity settings (Administration > Entity Manager > {entity_name} > Edit) or use the API Before-Save Script: https://docs.espocrm.com/administrat...licateconflict.

[drychly]

Hi @lazovic,

I am not able to do it via Entity Manager. My current EspoCRM version is 9.1.2.

These are the options I see there:

I will try then via API Before-Save Script.

Thank you

[lazovic]

drychly,

You need to go directly to the Administration > Entity Manager > Contact > Edit (button):



Here you can see the "Duplicate check fields" option at the bottom of the page.

[drychly]

Ah, I see. Thanks. But this will only warn user that the e-mail is duplicate, and will allow to create the contact anyways.

[lazovic]

drychly,

In this case, you can use the API Before-Save Script.

In Administration > Entity Manager > Contact > Formula > API Before Save Script:

$id = record\findOne('Contact', null, null, 'emailAddress=', emailAddress);

if ($id) {
    recordService\throwBadRequest('There is already a contact with this email address in the system.')
}

In Administration > Entity Manager > User > Formula > API Before Save Script:

$id = record\findOne('User', null, null, 'emailAddress=', emailAddress);

if ($id) {
    recordService\throwBadRequest('There is already a user with this email address in the system.')
}

[drychly]

Thanks, it works.