Unique phone number

[Espire]

Hello,
Very nice CRM but we are having an issue while creating contacts or leads becase callers are able to add same phone number twice. Is there any way to make phone number unique? For example with message like "Phone number already exists".
Thank you

[Kharg]

You could try to add the key “unique”: true to the field in the entityDefs related file.

I don’t know if it will work for the phone number field

[Espire]

It seems that Unique is not available for the Phone number. ?
Is it possible to use the following to accomplish it https://docs.espocrm.com/administrat...icate-checking ?

[rabii]

Hello,
Very nice CRM but we are having an issue while creating contacts or leads becase callers are able to add same phone number twice. Is there any way to make phone number unique? For example with message like "Phone number already exists".
Thank you

Unique will not work, phone is saved in database in two different tables (phone_number) and (entity_phone_number). i think one way to do it, is to use formula so when the user create a new phone which already exist the formula should just delete that phone number, e.g a contact entity when a user create a new phone number for a contact and that phone number already exist then just delete the last one. see code below :

ifThen(phoneNumber && record\exists('Contact', 'phoneNumber=', $phoneNumber),
$entityPhoneNumberId = record\findOne('EntityPhoneNumber', null, null, 'entityId=', id);
record\update('EntityPhoneNumber', $entityPhoneNumberId, 'deleted', true);
);​ 

Otherwise you could use Save Error Handlers which come handy will display a message to the user preventing them from adding an existing phone. i have written a post about how to implement, you can just adjust the code to your entity and it should work.

http://https://forum.espocrm.com/forum/developer-help/developer-tutorials/92483-save-error-handlers-throw-backend-exception-handle-in-frontend-when-saving-a-record#post92483