Duplicate check for linked field

[shalmaxb]

It seems, that it is not possible to create a duplicate check, if the field is of type multiple link. Is there any way to implement that?

[lazovic]

Hi shalmaxb,

Perhaps these examples may be useful: https://docs.espocrm.com/administrat...icate-checking.

[shalmaxb]

Unfortunately I did not get it to work. This solution asks for a recordService, which I don`t know, where and how to implement.

[lazovic]

You don't need to create anything new, this is built-in formula functionality that will be available in EspoCRM 7.5.

Please describe exactly how the duplicate check should work for you and with what links/relationships/field types, and I will try to create a suitable formula for you.

[shalmaxb]

lazovic, thank you for your nice offer. I have another thread, where I attached a graphic for my entities:

https://forum.espocrm.com/forum/general/93432-one-to-one-relationship

The only thing I changed there already is the n:n relationship, it is a 1:n now. But ther is the problem with the one-to-one relationship where I would like to have the linked record duplicate checked.
I hope, it is understandable, what I wrote.

[shalmaxb]

lazovic

I solved that problem by duplicate check. Will not prevent from creating a duplicate, but the alert message appears.
The solution was to get rid of the one-to-one relationship and using a 1:n instead. I made the duplicate check on top of the linkedFieldId and that worked.

Thank you again for you help and a fat kudos to espoCRM!