You need to sign in to do that
Don't have an account?
John Manager Training Dep
Validation rule on a standard object to check if the combination for field A and B already exists?
Hi Team,
I have a requirement where the new case should not be created if field A(Contact ID lookup field) & field B(custom text field) combination already exists.
Is this possible to achieve the requirement using validation rule?
I know for a fact that as on date, VLOOKUP cannot be used on standard objects.
Any constructive suggestions are much appreciated!
Thanks!
I have a requirement where the new case should not be created if field A(Contact ID lookup field) & field B(custom text field) combination already exists.
Is this possible to achieve the requirement using validation rule?
I know for a fact that as on date, VLOOKUP cannot be used on standard objects.
Any constructive suggestions are much appreciated!
Thanks!
You need to create a new Field say A_concat_B__c and make sure you mark it unique.
Via workflow or Processbuilder update that field value with A+B.
Mark it the best answer if it helped
If there is a value in field C, duplicate combination of field A and field B is allowed.
Any constructive suggession is greatly appreciated.
IF ISBLANK( C )
THEN: A_concat_B__c = A + B
ELSE: A_concat_B__c = A + B + RecordId ( WIll make it unique automatically if C is not blank)
Is it possible to change the text of error message displayed by process builder when duplicate scenario is identified?
https://trailhead.salesforce.com/content/learn/modules/sales_admin_duplicate_management/sales_admin_duplicate_management_unit_2