Contents
What happens if I try to duplicate a custom field?
If a custom field on a custom object has unique set to true, and you try to insert a duplicate value, a DUPLICATE_VALUE exception code is returned. The user logged in for API activity must be have the “Customize Application” permission.
How do I create a duplicate detection rule?
To create a new duplicate detection rule, choose New. Type a name and description. To edit an unpublished existing duplicate detection rule, choose the duplicate detection rule. To edit a published duplicate detection rule, select the rule. On the Actions menu, choose Unpublish, and then choose the rule.
How to ignore blank values in duplicate detection?
If you don’t want the rule to consider blank fields (null values) as equal while identifying duplicates, select the Ignore Blank Values check box. If the duplicate detection rule contains only one condition, blank values are ignored during duplicate detection job.
How to identify duplicate field values in geodatabase?
To distinguish between the first/original record and duplicates, refer to Knowledge Base article “Identify duplicate field values” in the Related Information section below. Warning: The procedure outlined is not available for data stored in file geodatabase or shapefile formats.
How to make a standard field a unique identifier?
Making the Product2.ProductCode field unique would be really helpful to maintain integrity of the Product Master. Having this option in the standard field removes the need for extra controls. This is default standard stuff for any system it should be for Salesforce also.! Really odd that this is not an option.
Where do I find custom fields in Salesforce?
To identify the standard objects that support custom fields, see the table in Relationships Among Custom Objects. Custom objects have an associated name field that is defined by your Salesforce administrator. Custom fields must have unique names within the same object.
What does false mean in a custom field?
A value of false means the field can have the same value in different records of that custom object type. If the caseSensitive field is set to true, the uniqueness (if enabled) is case sensitive. For example “ABC” and “abc” are considered two unique values.