Issue Mapping Custom Fields to Salesforce Event Object.

Hello, I have created a form for Salesforce. I am trying to map values (input into the form) to the Event object in Salesforce. However, although the form fields are visible in the integration editor, none of the Form's custom fields (corresponding to custom fields on the Event object in Salesforce) are selectable.

I have tried using the Spreadsheet widget (which cannot be mapped to fields in Salesforce) and recreated my form using numerical fields. Is it not possible to map fields to the Event object?

Thank you in advance for your assistance.

Kind regards,

Bill

Hi Bill,

Thanks for reaching out to Jotform Support. Can you explain a bit more about your Cable object field in Salesforce, is it a number field? If so, you can add a number object field in Salesforce. Change your Cable short text field in your form to a number field in a few easy steps. Let me show you how:

1. In Form Builder, on the left side of the screen, click on Add Element.
2. Scroll down and click on or drag Number.

Here is a screenshot in the Salesforce integration, I can now match the fields.

Give it a try and reach out again if you have any other questions.

Hi Kalo,

Thank you for your assistance. I followed your suggestion and replaced the various input fields with the number field. That enabled me to map the corresponding Salesforce Object fields in the integration panel.

Unfortunately, even after revising the form and the integration mapping, I may be just be facing the limitations of the Event object and how it relates to Campaigns in Salesforce. What I want to achieve is to use this reporting form I've created in Jotform to create new Events in Salesforce that map to specific Campaigns in Salesforce. I created the Campaign Name and Parent Campaign fields (picklists) in Jotform to accomplish this task, but these fields only exist on the Campaigns object in Salesforce. Since my form is based on the Event object, the only relevant Salesforce field I can choose under the Object Fields options is "Related to ID". Would it be possible for the form user to either select (via dropdown) or input the Property for example and have a Jotform find the correct Campaign ID (unique identifier for the Campaign in Salesforce, e.g. 701Ul00000K41RuIAJ)?

Thank you for your continued help!

Best,

Bill

Hi Kalo,

I checked the Activity Log in Jotform and learned that my form mapping is failing due to required fields in Salesforce:

Create or update Event is failed

{

Error Message: Required fields are missing: [DurationInMinutes]

Error Code: REQUIRED_FIELD_MISSING

Fields:

DurationInMinutes

}

{

Error Message: Required fields are missing: [ActivityDateTime]

Error Code: REQUIRED_FIELD_MISSING

Fields:

ActivityDateTime

}

Is there a way to configure the a date/time field in Jotform to resolve this and enable my form to create a new Event?

Thanks again for your continued help!

Bill

Hi again, Kalo. I promise, this will be my last message for tonight!

I added two date/time fields to my form--one for the start time and another for the end. But, I still can't get the form to play nice with Salesforce. Here's my latest error message:

{

Error Message: 'Collection Day: Walnut Place' AND StartDateTime = '' AND EndDateTime ^ ERROR at Row:1:Column:223 value of filter criterion for field 'StartDateTime' must be of type dateTime and should not be enclosed in quotes

Error Code: INVALID_FIELD

}

I feel that there must be a solution to this problem, but it is proving to be very difficult to find.

Thanks again!

Bill

Hi Bill,

Thanks for keeping us updated on your progress. Regarding the Campaign Name and Parent Campaign mapping, Jotform does not currently support a built-in lookup function to find and match a Campaign ID based on a selected Property. However, one possible workaround is to use conditional logic to assign the correct Campaign ID to a hidden field in your form based on the user’s selection. Then, you can map this hidden field to the Related to ID in Salesforce.

For the required Salesforce fields, DurationInMinutes & ActivityDateTime, have you tried removing and reintegrating your form with Salesforce? Sometimes, Salesforce does not recognize newly added fields until the integration is refreshed. If you're done with this, could you take a screenshot or record a screen video of what you're seeing on your end?

This will help us try to replicate the issue on our side. If further investigation is needed, we’ll create a performance ticket and forward the screenshot or video to our developers. You can share the video on a public platform like Google Drive or Dropbox, or use Loom to record it and send us the link. In the meantime, let me show you how to post a screenshot to our Support Forum:"

1. On the Support Forum page, scroll down to the Your Answer section and click on the Image icon.

2. Drag and drop your image into the Upload box, or click on it and select your file.

3. Then, click on the Add button in the bottom-right corner of the window.

4. To resize it, click on your screenshot and then click on one of the boxes in the corners, and drag it inward.

5. Once you're finished, click on the Post Answer button at the bottom right of the Your Answer section.

That's it. Once we hear back from you, we'll be able to help you with this.

Hi Cyrus,

Your suggestion to remove and then reintegrate the form did the trick. I just successfully tested the form 3 times, thanks to your instructions. I still have work to do, but now that I've established that it works, it should be smoother sailing from here.

Thanks again for your help and have a good night!

Bill