You need to sign in to do that
Don't have an account?
markbruso
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?
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