{"id":40799,"date":"2022-07-25T16:54:32","date_gmt":"2022-07-25T16:54:32","guid":{"rendered":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/?p=40799"},"modified":"2024-06-19T13:30:34","modified_gmt":"2024-06-19T13:30:34","slug":"duplicate-management-when-creating-records-via-123-form-builder","status":"publish","type":"post","link":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/duplicate-management-when-creating-records-via-123-form-builder\/","title":{"rendered":"[AppExchange \u2013 123FormBuilder] Duplicate management when creating records"},"content":{"rendered":"\n

Duplicate records cause trouble for the business, as well as the admin. Clients may get angry if multiple sales reps contact them with the same purpose. At the same time, sales reps lose trust in the CRM and question the validity of the data they rely on. So what can you do to prevent duplicate records?<\/p>\n\n\n\n

\n\n\n\n

On Salesforce side<\/h2>\n\n\n\n

Use Matching and Duplicate<\/b> rules. If you need more details about setting this up, you can always check this Trailhead article<\/a>. Depending on how the Duplicate Management<\/b> is configured, creating a duplicate record can be blocked altogether or it can be allowed to show an alert. To bypass this alert enable the option Override Duplicate Rules when creating\/updating record <\/a>from the mapping interface, under Record Preferences.<\/p>\n\n\n

\n
\"\"<\/a><\/figure>\n<\/div>\n\n\n

When choosing to block duplicate records from being created, the 123FormBuilder app will also throw an error and won\u2019t create the record, if the form is set up to create a new record instead of updating an existing record.<\/p>\n\n\n\n

\n\n\n\n

On 123FormBuilder side<\/h2>\n\n\n\n

In the form builder<\/a> app, in Salesforce Integration \u2192 Object Mapping<\/b>, under Record preferences<\/b>, make sure to choose the Update existing record<\/b> option for Action to perform<\/b>. <\/p>\n\n\n

\n
\"Salesforce<\/a><\/figure>\n<\/div>\n\n\n

This setup allows adding a single criterion for identifying an existing record in Salesforce. But most times, the Matching and Duplicate rules created in Salesforce involve multiple criteria. For example: for Contact, one may use Last Name <\/em>and Email <\/em>or Date of birth<\/em>.<\/p>\n\n\n\n

This is why we recommend using the Record ID as a criterion for Updating existing record<\/b> when setting up the Object Mapping.<\/p>\n\n\n\n

Since your form visitors don\u2019t know the Salesforce Record ID, here\u2019s what you can do to identify it:<\/p>\n\n\n\n