You need to sign in to do that
Don't have an account?
raju123
Frequently changing picklist values
Hi All,
Please give me solution for my Requirement.
Requirement:
In our project....Picklist values in objects are changing frequently. Might be weekly once. More than 800 picklist values are there in our objects. But Updating them manually and update the related records is difficult process for every week.
So is there any solution for this and Is there any way to do with any middleware .
Please give me solution. Thanks in advance
Any one please respond for this. its an urgent task...Thans again
Though manual, i would suggest you use the replace method to update picklist values as this will automatically update records that have the old picklist value with the new one:
Reference:
http://starrforce.com/2013/01/salesforce-best-practice-modifying-salesforce-picklist-values/
"Another option is to create a new value and then globally replace an existing value. This is handy when combining values or if you want to keep your report filters intact using new or existing values.
When viewing the picklist values of a Salesforce field, use the “Replace” button and enter the value you want to replace. Then select the value to replace it with. You will need to have any new values added before replacing existing values.
This is a global change and will replace the picklist value for all existing records, including records in the recycle bin. Also, this will update the Modified By date and time for all records where the value was replaced."
But....We have an object with 4 picklist fields 800 values each and we have to update 2 objects. but these many times Replacing values manually is difficult