To know a record is already exist in an entity(Eg:Leads)

[sujithraalink]

configuring workflow from front end, how to check a record is already exist ? Please help

[sujithraalink]

Iam new to espo, I do want to search with phone number in an entity. if phone number already exist i have to get its count >= 1. can i do it in actions in workflow or using formula.

[yuri]

Possible w/ formula function record\exists: https://github.com/espocrm/documenta...d#recordexists

[Maximus]

Hello,
it is very easy to find all records with empty or not empty field in entity. You just have only to run the search with the filter. See attachments.

[sujithraalink]

Thanks Sir, I know this. but i want to make a check for duplicate entry and need to give a status on each duplicate entry.
And I tried this as you said
ifThen(record\exists('Contact', 'phoneNumber=', phoneNumber), flag = true). Here after a new record is created , trying to check phone number is already exists, if exists then need to update flag as true in newly created record. Please help.

[dreginald]

I tried creating this workflow and it is not working. It is showing Duplicate for every record created. Can someone advise me how to use this formula. Screenshot attached.

description=ifThen(record\exists('Lead', 'phoneNumber=', phoneNumber), "Duplicate");

[dreginald]

With reference to my previous post, I have found a better way to identify the duplicate leads, by using record/count and filtering out all counts above 1.
noOfLeadsWithSamePhoneNo=record\count('Lead', 'phoneNumber=', phoneNumber);