Skip to main content
Topics#FormulasQuestion de Chakra Varthi Konreddy
Chakra Varthi Konreddy (Salesforce) a posé une question dans #Formulas
31 mars 2015, 15:09

How to avoid duplication of records based on 3 fields (data type:Text)

Hi 

i have a scnario:3 fields (data type:Text) First Name,Middle Name,Last Name, if any Duplicate record is going to be created with same values in those three fields, that operation should fail by throwing an error,Is there any possible way to achieve this,through (UI configuration or trigger),

I wonder..how to compare text fields that too 3 Text fields.
3 réponses
  1. David Zhu
    31 mars 2015, 19:04
    You can create a formula text field concatenating three fields.

    Then add a validation rule to prvent the duplication.

    ie. fomula field: concatenatingField.

    in validationg rule, check condition: PRIORVALUE( concatenatingField__c ) = concatenatingField__c to prevent the duplication.
Rédiger une réponse...
0/9000