{"id":40483,"date":"2022-07-25T16:54:29","date_gmt":"2021-09-28T15:21:32","guid":{"rendered":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/?p=40483"},"modified":"2024-06-19T13:29:13","modified_gmt":"2024-06-19T13:29:13","slug":"error-the-record-could-not-be-created-in-the-objectname-object-reason-use-one-of-these-records","status":"publish","type":"post","link":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-the-record-could-not-be-created-in-the-objectname-object-reason-use-one-of-these-records\/","title":{"rendered":"Error: The record could not be created in the [ObjectName] object. Reason: Use one of these records? | 123FormBuilder"},"content":{"rendered":"\n

Why does it show up? <\/h2>\n\n\n\n

The error message indicates that you have a Duplicate Rule active in your organization, with the action set on Allow and Show alert.<\/p>\n\n\n\n

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

When manually creating\/updating a record in Salesforce – a prompt will show up with the Alert text and one can interact with that prompt. However, via API, no such interaction is available and 123FormBuilder app will fail to create\/update the record, with the Alert text as a failed message:<\/p>\n\n\n

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

How to check for Duplicate or Matching rules<\/h2>\n\n\n\n

Check if you have an active Duplicate Rule<\/b> for the object indicated in the error, and what is the criteria. In order to verify this, in Salesforce \u2192 Setup<\/b> search for Duplicate Rule<\/b>.<\/p>\n\n\n

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

While still in Salesforce \u2192 Setup<\/b>, check the Matching Rule<\/b> to see what fields are verified to prevent duplicates.<\/p>\n\n\n

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

How to fix it?<\/h2>\n\n\n\n

1. To avoid this error and make sure that upon submission the record will be created\/updated when the Allow action is selected in the duplicate rule, you can enable the option Override Duplicate Rules when creating\/updating record<\/b> from the mapping interface, under Record Preferences:<\/p>\n\n\n\n

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

Besides enabling the Override Duplicate Rules when creating\/updating record <\/b>option, we recommend setting the form to update based on the field you use in the Matching rule in Salesforce, or create a lookup<\/a>\/query with those fields to return the record ID. Details below.<\/p>\n\n\n\n

2. For more complex Matching Rules: <\/b><\/p>\n\n\n\n

Complex Matching Rules can involve multiple fields in the matching verification (e.g. FirstName, LastName, and Email in the screenshot below), or if another object is checked for duplicate values in relation to the mapped one.<\/p>\n\n\n\n

To fix this, you need to create a query that searches for the record ID of the object involved in the Matching Rule. The query result can then be used to update the records.<\/p>\n\n\n

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

In the 123FormBuilder app, go to the Salesforce Integration \u2192 Query<\/b> section and add your query.<\/p>\n\n\n\n

Here’s a query example:<\/p>\n\n\n\n

SELECT ID FROM Lead WHERE FirstName=`[{First NAme (1822184)}]` AND LastName=`[{Last name {1822185)}]` AND email=`[{Email(1822187)}]`<\/pre>\n\n\n
\n
\"Salesforce<\/a><\/figure>\n<\/div>\n\n\n
Once you validate the query, follow the same steps explained above. In the Object Mapping<\/b> section, under Record Preferences<\/b> choose Update records if<\/b> Salesforce Record ID field<\/em><\/strong> is Query result<\/strong><\/em>, in this example, the Record ID<\/em><\/strong>:<\/p>\n\n\n
\n
\"Update<\/a><\/figure>\n<\/div>\n\n\n
Important Note<\/b><\/p>For existing entries with this error, you can update the mapping with the solution explained above. Then, from the Failed Applications<\/strong> tab in the forms Submission<\/strong> section, you can click on Resend to Salesforce<\/em> to trigger the mapping again.<\/span><\/div>\n\n\n
\n
\"Resend<\/a><\/figure>\n<\/div>","protected":false},"excerpt":{"rendered":"
Why does it show up? The error message indicates that you have a Duplicate Rule active in your organization, with the action set on Allow and Show alert. When manually creating\/updating a record in Salesforce – a prompt will show up with the Alert text and one can interact with that prompt. However, via API, […]<\/p>\n","protected":false},"author":13,"featured_media":-1,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[134],"tags":[],"class_list":["post-40483","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-123formbuilder-appexchange"],"yoast_head":"\nThe record could not be created. Use one of these records?<\/title>\n<meta name=\"description\" content=\"The error message indicates that you have a Duplicate or Matching Rule active in your organization. Here's how to fix it.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-the-record-could-not-be-created-in-the-objectname-object-reason-use-one-of-these-records\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Error: The record could not be created in the [ObjectName] object. Reason: Use one of these records? | 123FormBuilder\" \/>\n<meta property=\"og:description\" content=\"The error message indicates that you have a Duplicate or Matching Rule active in your organization. Here's how to fix it.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-the-record-could-not-be-created-in-the-objectname-object-reason-use-one-of-these-records\/\" \/>\n<meta property=\"og:site_name\" content=\"123FormBuilder Knowledge Base\" \/>\n<meta property=\"article:published_time\" content=\"2021-09-28T15:21:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-06-19T13:29:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2024\/06\/uno.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"4 minutes\" \/>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"The record could not be created. Use one of these records?","description":"The error message indicates that you have a Duplicate or Matching Rule active in your organization. Here's how to fix it.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-the-record-could-not-be-created-in-the-objectname-object-reason-use-one-of-these-records\/","og_locale":"en_US","og_type":"article","og_title":"Error: The record could not be created in the [ObjectName] object. Reason: Use one of these records? | 123FormBuilder","og_description":"The error message indicates that you have a Duplicate or Matching Rule active in your organization. Here's how to fix it.","og_url":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-the-record-could-not-be-created-in-the-objectname-object-reason-use-one-of-these-records\/","og_site_name":"123FormBuilder Knowledge Base","article_published_time":"2021-09-28T15:21:32+00:00","article_modified_time":"2024-06-19T13:29:13+00:00","og_image":[{"url":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2024\/06\/uno.png","type":"","width":"","height":""}],"author":"admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"admin","Est. reading time":"4 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-the-record-could-not-be-created-in-the-objectname-object-reason-use-one-of-these-records\/#article","isPartOf":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-the-record-could-not-be-created-in-the-objectname-object-reason-use-one-of-these-records\/"},"author":{"name":"admin","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#\/schema\/person\/ac765b93d6689ec0f4ee6f6e040d66ea"},"headline":"Error: The record could not be created in the [ObjectName] object. Reason: Use one of these records? | 123FormBuilder","datePublished":"2021-09-28T15:21:32+00:00","dateModified":"2024-06-19T13:29:13+00:00","mainEntityOfPage":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-the-record-could-not-be-created-in-the-objectname-object-reason-use-one-of-these-records\/"},"wordCount":421,"commentCount":0,"image":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-the-record-could-not-be-created-in-the-objectname-object-reason-use-one-of-these-records\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2024\/06\/uno.png","articleSection":["AppExchange"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-the-record-could-not-be-created-in-the-objectname-object-reason-use-one-of-these-records\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-the-record-could-not-be-created-in-the-objectname-object-reason-use-one-of-these-records\/","url":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-the-record-could-not-be-created-in-the-objectname-object-reason-use-one-of-these-records\/","name":"The record could not be created. Use one of these records?","isPartOf":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-the-record-could-not-be-created-in-the-objectname-object-reason-use-one-of-these-records\/#primaryimage"},"image":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-the-record-could-not-be-created-in-the-objectname-object-reason-use-one-of-these-records\/#primaryimage"},"thumbnailUrl":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2024\/06\/uno.png","datePublished":"2021-09-28T15:21:32+00:00","dateModified":"2024-06-19T13:29:13+00:00","author":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#\/schema\/person\/ac765b93d6689ec0f4ee6f6e040d66ea"},"description":"The error message indicates that you have a Duplicate or Matching Rule active in your organization. Here's how to fix it.","breadcrumb":{"@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-the-record-could-not-be-created-in-the-objectname-object-reason-use-one-of-these-records\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-the-record-could-not-be-created-in-the-objectname-object-reason-use-one-of-these-records\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-the-record-could-not-be-created-in-the-objectname-object-reason-use-one-of-these-records\/#primaryimage","url":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2024\/06\/uno.png","contentUrl":"https:\/\/cdn.marketing123.123formbuilder.com\/wp-content\/uploads\/sites\/3\/2024\/06\/uno.png"},{"@type":"BreadcrumbList","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-the-record-could-not-be-created-in-the-objectname-object-reason-use-one-of-these-records\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/"},{"@type":"ListItem","position":2,"name":"Error: The record could not be created in the [ObjectName] object. Reason: Use one of these records? | 123FormBuilder"}]},{"@type":"WebSite","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#website","url":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/","name":"123FormBuilder Knowledge Base","description":"Search our documentation platform for answers, service specifications and 3rd-party integrations.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/#\/schema\/person\/ac765b93d6689ec0f4ee6f6e040d66ea","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/41383a571ede8f1257b128aa53a410cc1ea4c1901ac8cea3776cba5438d24843?s=96&d=https%3A%2F%2Fui-avatars.com%2Fapi%2Fadmin%2F96%2Ff3f3f3%2Faaa%2F1%2F0.5%2Ffalse%2Ftrue&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/41383a571ede8f1257b128aa53a410cc1ea4c1901ac8cea3776cba5438d24843?s=96&d=https%3A%2F%2Fui-avatars.com%2Fapi%2Fadmin%2F96%2Ff3f3f3%2Faaa%2F1%2F0.5%2Ffalse%2Ftrue&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/41383a571ede8f1257b128aa53a410cc1ea4c1901ac8cea3776cba5438d24843?s=96&d=https%3A%2F%2Fui-avatars.com%2Fapi%2Fadmin%2F96%2Ff3f3f3%2Faaa%2F1%2F0.5%2Ffalse%2Ftrue&r=g","caption":"admin"},"url":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/author\/admin\/"}]}},"_links":{"self":[{"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/posts\/40483","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/comments?post=40483"}],"version-history":[{"count":19,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/posts\/40483\/revisions"}],"predecessor-version":[{"id":48999,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/posts\/40483\/revisions\/48999"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/"}],"wp:attachment":[{"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/media?parent=40483"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/categories?post=40483"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/wp-json\/wp\/v2\/tags?post=40483"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}