I would like to get a suggestion on centralizing pickilst values.
In salesforce, we need to define picklist values in each object for same kind of fields. For example, i want to add '
status' field in multiple objects. The picklist values also needs to be defined in each objects.
Instead, i would like to centralize the picklist values, so that, when added status values in that list, it will correspond the same value in each objects.
For this, I am thinking of creating another object called '
Picklist Value'. This will hold picklist values for each category, which in turn can be used in multiple objects.
eg My object '
Picklist Value' contains following field :
Name Value Category
Draft Draft Status
Open Open Status
US United States Country
CA Canada Country
One major disadvantage with this approach is that, i lose translation capability provided by salesforce. Is this the best way to handle the centralization of picklist values? Or is there any better way?