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

Table that holds picklist values


Is there any table that holds the picklist values by object name.  We need to import data from Salesforce into our product for which we are using combination of Partner API & SOQL. I would like to know if we can use SOQL to select the possible picklist values given an object name or object name & record type.

Thank you, for your responses.




If you are using Web service then you will need to use the PartnerWSDL describeSObjects() method to extract the picklist value of field. 

Judhajit MandalJudhajit Mandal
Please explain.
I am a Salesforce newbie, and I want to auto populate a picklist in which I want the picklist values to come from a pre-created Table. Suggest if that can be done!
Larry ValdezLarry Valdez
I'm looking for the same thing, if a new record is created on an object and the record type = a particular value I want the name of the new record to be added as a selectable value in a picklist automatically and if the record type is changed I want the value removed from the picklist.