0

When I imported my contacts it created duplicates of all entries. Is there away to sort and remove them all at once?

duplicate entries

1 reply

null
    • Alexander_Koenig
    • 6 yrs ago
    • Reported - view

    Hi, you can use a formula to identify duplicates. 

    Here is an example: 
    You can insert a formula of the following form into the appropriate  table (in the example Contact) in the field "Trigger after update" of the table properties: 

    let myFirstName := 'First name';
    let myLastName := 'Last name';
    let cntFirstName := cnt((select Contact)['First name' = myFirstName]);
    let cntLastName := cnt((select Contact)['Last name' = myLastName]);
    if cntFirstName > 1 and cntLastName > 1 then
    alert("Duplicate!");
    'First name' := null;
    'Last name' := null
    end

    The system checks whether the fields First name and Last name already contain the same combination of names in another data record.
    If this is the case, a message "Duplicate!" appears and the fields are cleared again.
    If you do not want to perform the check at table level (i.e. every time any field content is changed in the table), you can also insert the script at each of the individual fields in the same option ("Trigger after update") of the field properties. 

Content aside

  • 6 yrs agoLast active
  • 1Replies
  • 1584Views