function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
markbrusomarkbruso 

Pick List Questions

1)  Is it possible to populate the values for a pick list by querying other data with SFDC?

2)  I want to add a pick list for 'State' and have the choices limited to the 50 states.  Do I really have to enter all 50 states in manually?

ScotScot

Mark,

While not a direct answer ... what I've done for tasks like this is to build a list of the values and then paste them into the standard interactive dialog for adding values to the picklist.

For example, if you have a list of the states in a .txt or .xls file, simply:

   >  Select them and copy
   >  Go to the dialog for adding values to the pick-list, and paste them in.

While there are probably much better ways to get the the 50 state values, you could obtain them from your salesforce records by:

   > Do a report from your account records of state values.
   > Export that to Excel
   > Use a pivot table to eliminate duplicates
   > Edit out errors