How to View Salesforce Integration Log Details

Salesforce Integration Logs allow you to identify and resolve integration issues quickly, reducing system downtime and preventing data discrepancies. With error notifications, you can take immediate action when an error occurs, eliminating the need to manually check the logs. These logs provide detailed records of all data transfers between Jotform and Salesforce. Common errors often arise from mismatched configurations between Jotform integration and Salesforce settings.

First, you have to access the Action Logs to view the errors. You can’t do that without editing the integration. Here are the steps:

1. In the Form Builder, go to the Settings tab.
2. Click Integrations on the left panel.
3. Choose Salesforce from the list.

4. Click the Edit Integration button.

5. Finally, click the See Action Logs to view the errors.

Here’s an example of the error logs:

To overcome these errors, general solutions are to correct the Jotform Form Field’s options, make form fields required, or add permissions on Salesforce. Below are the most common errors you’ll find and the corresponding solutions:

Bad Value for Restricted Picklist Field

Error code: INVALID_OR_NULL_FOR_RESTRICTED_PICKLIST

The mismatching options between the Jotform form field and the Salesforce picklist API Names cause this error.

The possible solutions to this case are:

Method #1: Match the form field options to Picklist API names

Assume a Single Choice field is mapped to a Picklist. The options of the Single Choice field and the Picklist API names should perfectly match, as shown in the images below:

Method #2: Allow the picklist to accept values that are not defined in the picklist value set

To do this, you must edit your Picklist field in Salesforce and uncheck the “Restrict picklist to the values defined in the value set” option. See the below image for the option:

See also: Salesforce – INVALID_OR_NULL_FOR_RESTRICTED_PICKLIST.

Duplicate Records Detected

Error code: DUPLICATES_DETECTED

While creating a record at Salesforce from Jotform submission data, the request can be rejected by Salesforce due to Salesforce’s duplicate rules.

The possible solutions to this case are:

Method #1: Adding an updated record matching the rule

If you’ve chosen to Create a record when you first did the Salesforce integration, edit it and ensure that the “Update an existing record” option is enabled and a matching rule is set. You can add as many rules as you want, but matching with the Email Address field is recommended. The rule checks the records and will automatically determine the action for you – to update the record instead of throwing an error.

Method #2: Disabling the duplicate rule

Turning off the duplicate rule in the chosen object will also work, but it is not recommended if you wish to keep your data free of duplicate information from the same user. If you wish to do it this way, here are the steps:

1. In your Salesforce dashboard, go to the Setup page.
2. In the Quick Find box, search for Duplicate Rules.
3. Click Duplicate Rules from the result. It is under the Duplicate Management section.
4. Click the Standard Lead Duplicate Rule of the chosen object from the list of duplicate rules. In the below example, we have the Lead as the object.

5. Click the Deactivate button, and that’s it!

See also:

• Disable Account Duplicate Rule
• Fixing Import Errors: DUPLICATES_DETECTED

Missing Required Field

Error code: REQUIRED_FIELD_MISSING

You’ll get this error when your Salesforce object has required fields mapped to an optional Jotform field, and your users skip it upon submitting their data. To fix this error, you must set the Jotform field as required.

See also: How to Set a Required Field.

Data Value Too Large

Error code: CANNOT_EXECUTE_FLOW_TRIGGER

When you find an error code with a “STRING_TOO_LONG” message, it means that a question answer has more characters than the Salesforce record’s field limit. Below are the solutions to this error:

Method #1: Set a character limit to the Jotform field

The Character Limit is found on a Short Text Entry field. It’s called the Entry Limit on the Long Text Entry field.

See also: How to Set Entry Limits on Short and Long Text Fields.

Method #2: Change the custom field type on Salesforce

You can change your custom field type according to your form question answer lengths. You can find the custom field type character lengths in this document.

See also: Salesforce – Change the Custom Field Type.