{"id":40472,"date":"2021-09-28T15:23:20","date_gmt":"2021-09-28T15:23:20","guid":{"rendered":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/?p=40472"},"modified":"2023-10-12T15:26:17","modified_gmt":"2023-10-12T15:26:17","slug":"error-the-record-could-not-be-created-in-the-object_name-object-reason-field-name-bad-value-for-restricted-picklist-field-sentvalue","status":"publish","type":"post","link":"https:\/\/123formbuilder.polarbuildingcleaning.net\/docs\/error-the-record-could-not-be-created-in-the-object_name-object-reason-field-name-bad-value-for-restricted-picklist-field-sentvalue\/","title":{"rendered":"Error: bad value for restricted picklist field | 123FormBuilder"},"content":{"rendered":"\n

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

The restricted picklist error means that the form is trying to create a record with a picklist value that doesn\u2019t exist in Salesforce.<\/p>\n\n\n\n

If the submitted value is not identical to the API value name in Salesforce, data won\u2019t be sent to Salesforce. In the forms Submissions<\/b> section (Failed Applications<\/b> tab), you’ll receive the following error:<\/p>\n\n\n

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

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

Since 123FormBuilder works with the Salesforce API, it relies on the API Name. No worries, you don\u2019t have to put the API value on the form as a choice. However, you need to provide the API value in the Object Mapping<\/b> section.<\/p>\n\n\n\n

To fix the restricted picklist error, first, you need to check the API values for that picklist in Salesforce.<\/p>\n\n\n\n

Then, go to the form Salesforce Integration \u2192 Object Mapping<\/b>, identify the picklist field, hover and click on the Alternative Values<\/b> icon and provide the exact API values:<\/p>\n\n\n

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

In the below example, the Salesforce API values are just codes that mean nothing to the form visitors. I want to display the product name on the form, but the value sent to Salesforce needs to be that code. Therefore, I use Alternative values<\/strong> and make sure to add the values exactly the same as they are in Salesforce, with proper capitalization and no leading or trailing spaces:<\/p>\n\n\n

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

If the API name of the value is correct and you’re still receiving the error message, verify that the value is selected for your Record Type.<\/p>\n\n\n\n


Go to Setup -> Object Manager -> Find the Object -> Navigate to Record Types -> Select the record type and ensure that the picklist value is displayed in the Selected Values column:<\/p>\n\n\n

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

Related articles<\/b><\/p>\n\n\n\n