Overview
Dynamic Picklists are multiple-choice questions that get their list of choices directly from Salesforce. Values are populated from Salesforce when the form loads, so the choices in your picklist always stay current without having to refresh the schema.
You can configure your Dynamic Picklists to get their list of choices from:
- Salesforce Picklist Field
- Salesforce Object Lookup (Basic)
- Salesforce Object Lookup (Advanced)
- When cloning a form with a Dynamic Picklist, you will need to reconfigure the Dynamic Picklist on the clone. The field will clone over but the configuration will not.
- Additionally, we recommend that you do not copy the configured Dynamic Picklist field within a form, and add a Dynamic Picklist field to predefined content or to a template.
- Currently, Dynamic Picklists do not work in conjunction with the No Overwrite feature.
- Finally, Dynamic Picklist fields are linked to the authenticated Salesforce user. If you change form ownership or change the authenticated user for your Dynamic Picklists, this will break the Dynamic Picklist field and you will need to re-authenticate.
Requirements
To use Dynamic Picklists, you will need:
- Permission to use the Dynamic Picklist feature (controlled by your FormAssembly administrator)
- Note: This permission is not set by default on new accounts so you may need to edit your permissions.
- A FormAssembly Essentials plan or above
- Access to a Salesforce instance
Learn more about user roles and permissions.
Set Up a New Dynamic Picklist
- Add a Drop-Down Menu field to your form
- Click on the field and choose Choices
- Click Salesforce Dynamic Picklist
- Select your existing authorization or connect to a new account.
- Note: A new token is generated each time you select "Connect to Salesforce" and log into Salesforce, so please use existing authentications if they're available to preserve your limited tokens.
- Note: A new token is generated each time you select "Connect to Salesforce" and log into Salesforce, so please use existing authentications if they're available to preserve your limited tokens.
- Click Next
- Select your Choices source by clicking on the Get choices from the dropdown box
- Salesforce Picklist Field
- Salesforce Object Lookup (Basic)
- Salesforce Object Lookup (Advanced)
This information can be Salesforce records for that object, or a particular picklist included on the object.
Return Two Or More Salesforce Fields
If you would like to return two fields or more from Salesforce, make sure that you have added additional text input fields to your form in advance. For example, if you would like to return a picklist of Account Names and have a second field filled with the related Account ID then you'll need to have your Dynamic Picklist field added to the form along with a text input field for the Account ID to pull into before you begin mapping.
Update a Dynamic Picklist v1 Field
If you have an existing field in your form that was set up using our previous version of Dynamic Picklists, here are a few things to note:
- The only action needed to switch from the older version of the feature to the newer version is to enter into the Form Builder.
- Existing Dynamic Picklist fields will continue to work as expected and all of your existing Prefill settings will migrate over.
- When you edit a field that was set up in Dynamic Picklist v1, you will see a new interface and can adjust your settings as needed.
Salesforce Picklist Field
- Choose Salesforce Picklist Field from the Get choices from dropdown.
- Choose your field from the Picklist Field dropdown.
- Choose to Enable or Disable the Allow Free Responses toggle. If you'd like to allow respondents to enter information into your Dynamic Picklist, select Enable.
- Choose to Enable or Disable the Refresh Salesforce Connection toggle. Enabling this toggle will allow the Salesforce connection to refresh (thereby clearing the cache) to ensure that previously selected values in a dropdown do not display again when the form is loaded at a later time.
- Click Next.
- You'll now see a preview of the data retrieved in your Dynamic Picklist.
- Click OK to save your Dynamic Picklist
- Save your form
Salesforce Object Lookup (Basic)
- Choose Salesforce Object Lookup (Basic) from the Get choices from the dropdown box
- Choose your field(s) in the Return the following field(s) dropdown box
- Add conditions and sorting specifications if needed
- Choose to Enable or Disable the Allow Free Responses toggle. If you'd like to allow respondents to enter information into your Dynamic Picklist, select Enable.
- Choose to Enable or Disable the Refresh Salesforce Connection toggle. Enabling this toggle will allow the Salesforce connection to refresh (thereby clearing the cache) to ensure that previously selected values in a dropdown do not display again when the form is loaded at a later time.
- Click Next.
- You'll now see a preview of the data retrieved in your Dynamic Picklist.
- Click OK to save your Dynamic Picklist.
- Save your form.
- Choose "A Text Value"
- Enter the field alias of your dynamic picklist
- Click "Next" and then "OK".
Salesforce Object Lookup (Advanced)
- Choose Salesforce Object Lookup (Advanced) from the Get choices from the dropdown box
- This is an advanced option that allows you to write a query to pull data into your Dynamic Picklist.
- Choose to Enable or Disable the Allow Free Responses toggle. If you'd like to allow respondents to enter information into your Dynamic Picklist, select Enable.
- Choose to Enable or Disable the Refresh Salesforce Connection toggle. Enabling this toggle will allow the Salesforce connection to refresh (thereby clearing the cache) to ensure that previously selected values in a dropdown do not display again when the form is loaded at a later time.
- Click Next.
- You'll now see a preview of the data retrieved in your Dynamic Picklist.
- Click OK to save your Dynamic Picklist
- Save your form.
Case Scenarios
Choices from Salesforce Object Lookup Results
- Angela is creating a form that will link new businesses to existing accounts. She already uses the standard Account object to store and manage account information in Salesforce. By using a Dynamic Picklist, she can create a field on her form that will show a choice for each record in her Salesforce instance. As she adds and removes records in Salesforce, the choices on her live form will automatically update.
Choices from Salesforce Picklist
- Amit uses lots of different forms to facilitate student registration. Each of his forms needs a field for the anticipated start term, but the list of available choices changes every semester. By using a dynamic picklist, Amit can populate the “Anticipated Start Term” field with a list of choices from his “Anticipated Start Term” picklist in Salesforce. When Amit updates his picklist in Salesforce, it will automatically update every one of his forms using that dynamic picklist.
Dynamic Picklist Limits
- Dynamic Picklists cannot be used in conjunction with conditional questions or menu dependencies.
- Dynamic Picklists cannot be conditioned on Checkboxes, Radio Buttons, Drop-Down Menu, or Multi-Select List fields at this time.
- For forms shared with the Collaboration feature, only the creator of the Dynamic Picklist is able to edit the picklist configuration.
- Dynamic Picklists render in LIVE mode so they cannot be seen in offline mode when using the FormAssembly Mobile App.
- Dynamic Picklists do not currently have a limit on the number of values they will pull in.
- Dynamic Picklist fields that are populated by restricted picklist fields in Salesforce will not work correctly if:
- the values are set via custom code
- the value is a calculated value
- Dynamic Picklists now have the option of restricting values. You'll be able to toggle the switch to allow or not allow outside values from respondents.
- In the dropdown list on the live form, you will see the first 100 results, until you define the query further by typing in a letter.
- Example: Your list has 200 countries. When you look at the form, it will show the first 100 of the list. If you type in the letter 'A', it will show the first 100 items that start with 'A'.