Salesforce Dynamic Picklist 

Overview

Salesforce Dynamic Picklists are multiple-choice questions that get their list of choices directly from Salesforce. Values are populated from Salesforce when the field is clicked by a respondent (unless there is a configured prefilled or default value), so the choices in your picklist always stay current without having to refresh the schema. 

You can configure your Salesforce Dynamic Picklist to get its list of choices from:

1. Salesforce Picklist Field
2. Salesforce Object Lookup (Basic)
3. Salesforce Object Lookup (Advanced)

Requirements

To use Salesforce Dynamic Picklists, you will need:

• Permission to use the Salesforce Dynamic Picklist feature (controlled by your FormAssembly administrator)

Set Up a New Salesforce Dynamic Picklist

1. Add a Drop-Down Menu field to your form

   

2. Click on the field and select Choices
3. Click Salesforce Dynamic Picklist
4. 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.
5. Select your Choices Source by clicking on the Get choices from dropdown
   • Salesforce Picklist Field
     • This type pulls a Salesforce Picklist Field from the record you set in the dynamic picklist.
   • Salesforce Object Lookup (Basic)
     • This type pulls a Salesforce Record from the object you set in the dynamic picklist.
   • Salesforce Object Lookup (Advanced)
     • This type also pulls a Salesforce Record from the object you set in the dynamic picklist, through the use of SOQL.

This information can be Salesforce records for that object, or a particular picklist included on the object.

Returning Multiple 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 before you begin mapping choices.

For example, if you would like to return a picklist of Account Names and have an additional field filled with the related Account ID, you will need to have your dynamic picklist field added to the form, along with a text input field for the Account ID, before you begin mapping. 

Salesforce Picklist Field

1. Select Salesforce Picklist Field from the Get choices from dropdown
2. Select a Salesforce Object from the Salesforce Object dropdown
3. Select the desired field from the Picklist Field dropdown
4. Choose to Enable or Disable the Allow Free Responses toggle 
   • If you'd like to allow respondents to enter information into your Salesforce Dynamic Picklist, select Enable. 
5. 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.
     

4. Click Next
5. You'll now see a preview of the data retrieved in your Salesforce Dynamic Picklist
6. Click OK to save your Salesforce Dynamic Picklist
7. Save your form

Salesforce Object Lookup (Basic)

1. Choose Salesforce Object Lookup (Basic) from the Get choices from dropdown
2. Select a Salesforce Object from the Lookup Salesforce Object dropdown
3. Choose your field(s) in the Return the following field(s) dropdown
   • When adding multiple fields to this section, the first field returned is the one shown in the dynamic picklist. Any other fields that are returned can be used to fill in other fields on the form. 
4. Add conditions and sorting specifications, if needed
5. Choose to Enable or Disable the Allow Free Responses toggle 
   • If you'd like to allow respondents to enter information into your Salesforce Dynamic Picklist, select Enable.
6. 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.
7. Click Next
8. You'll now see a preview of the data retrieved in your Salesforce Dynamic Picklist
   • On this page, you may map any additional returned fields to the form fields you want them to go to.
9. Click OK to save your Salesforce Dynamic Picklist
10. Save your form

Salesforce Object Lookup (Advanced)

1. Choose Salesforce Object Lookup (Advanced) from the Get choices from dropdown
2. Enter your SOQL query in the text field 
3. Choose to Enable or Disable the Allow Free Responses toggle
   • If you'd like to allow respondents to enter information into your Salesforce Dynamic Picklist, select Enable. 
4. 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.
5. Click Next
6. You'll now see a preview of the data retrieved in your Salesforce Dynamic Picklist
7. Click OK to save your Salesforce Dynamic Picklist
8. Save your form.

Salesforce Dynamic Picklist Limits

• Salesforce Dynamic Picklists cannot be used in conjunction with conditional questions or menu dependencies.
• Salesforce Dynamic Picklists cannot be conditioned on Checkboxes, Radio Buttons, Drop-Down Menus, or Multi-Select List fields at this time.
• For forms shared with the Collaboration feature, only the creator of the Salesforce Dynamic Picklist can edit the picklist configuration.
• Salesforce Dynamic Picklists do not currently have a limit on the number of values they will pull in.
• Salesforce 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

• Salesforce 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'.