Find Duplications
Use Cases 0 replies 1 like 0 votes 51 viewsOften we face a request to keep a unique values but still keep tracking the new instances the business gets.
In order to do it only using Origami we created the following entities:
- Inquiries
- Leads
- Admin
the Inquiries is the same as the leads structure the only difference is that the Phone number is Unique for Entity on the leads entity. it can be replaced with any other field such as Email, ID and so on..
The Inquiries entity has additional fields of relation to the lead and to the Admin and Hidden field "duplication trigger"
The Leads will have a relation field to the Inquiries
The Admin Entity should have a relation field related to the Inquiries and a Phone field (or the other unique field you choose).
The flow is as follow:
all the new Inquiries enter to the Inquiries entity
1st WF on Inquiries entity:
Trigger type - on creation
Conditions - if Phone number is not empty
Action - convert to Admin and we map the phone field in the phone fiedl in the admin.
2nd WF on the Admin Entity:
Trigger type - on creation
Conditions- if phone is not empty
and if relation to Inquiries isn't empty
Action - update fields:
A- Update the field "Duplication Trigger" to '1'
B- update the relation field and update the value (not the default selection)
of the related instance itself of the Lead relation field in the value of the Phone Number.
** it is important to set the relation to the lead field in the Inquiries entity to select from the Phone field (or the other unique field).
This part should relate the Lead if already exists
The 3rd WF on the Inquires Entity:
Trigger type- on field update - "Duplication Trigger"
Conditions-
"Duplication Trigger" = '1'
Relation to lead - Empty
Action - convert instance to leads entity
this WF will check if the lead related - if not it will create a lead.
if it related then this WF wont execute
if we would like to update the Related lead status (if we found a match)
then we need an additional WF:
Trigger type- on field update - "Duplication Trigger"
Conditions-
"Duplication Trigger" = '1'
Relation to lead -Not Empty
Action- update fields
"relation to lead" - the value in the related instance itself of the status - to "re-added as a lead" or any other value you wish.