Salesforce
Creating and updating Salesforce objects using Formsort forms
Access to the Salesforce integration is invite-only during testing. Please ask in the chat to be invited if you would like to try it out.
About the Salesforce Integration
Formsort allows creating and updating any Salesforce object with form data.
Objects are given an external ID by Formsort, corresponding to the responder UUID. When a form is filled out, if an object with the responder's responderUUID does not yet exist, it will be created. Otherwise, the existing object will be updated.
Credential setup
First, go to Integrations > Salesforce at the flow level
Click Add destination and Add a credential...
Enter your Salesforce username, password, and security token (which can be found in your personal account settings). If you already have a security token, you'll have to click on 'Reset My Security Token' to get the token.
Click Save credential
Salesforce object setup
For Formsort to know whether to create a new instance of an object, or to update an existing one, you (or an administrator of your Salesforce) will need to add an external field to your target object. This will store the formsort responder UUID, and will be used as a key to perform upsert operations.
To create the external ID by which Formsort will reference an object
Logs into their Salesforce
Go to Setup
Under Object Manager, click the Salesforce object that the integration will save to (example, ‘Contact’)
Go to Fields & Relationships
Click New to a custom field with type ‘text’
In the next dialog, add the following and ensure that:
Unique is checked
External ID is checked
Length is set to 200
Field label is something identifiable as being managed by Formsort, such as ‘formsort_responder_uuid’
Field mapping setup
Once a credential has been chosen, and you have modified your target object, you must set up how the integration will write data to Salesforce.
Go to Integrations > Salesforce in your flow.
Ensure the credential you have previously added is selected.
Select a Posting frequency to determine how often data should be sent.
Choose the object you previously set up in Salesforce Object Name
Choose the external ID that was previously set up under External ID Field Name
This field will store the responder UUID.
Click Edit Mapping to determine how variables within Formsort will be mapped to fields within your target Salesforce object.
Click Save at the top of the integration and re-deploy your flow for the changes to be picked up.
Last updated
