• Inok Systems

How to update a record that using picklist data type in Salesforce

User Rating:  / 0

You might have certain field in your forms that using picklist data type, for example in your form you have Location field which contains a picklist values (New York, London, Washington), now let say you have 100 employee records whose location is New York, and you want to bulk update 75 of them to Washington since they relocate their office from New York to Washington.

You might think that this can be done easily using Data Loader, however upon import you realize although the import messages says it’s successful, when you verify the record none of them were getting updated. This is a limitation of Data Loader.

To update a record that using picklist data type you can use Salesforce workbench, here’s the steps:

1.       Launch https://workbench.developerforce.com/login.php

2.       Login using your admin account


3.       From workbench menu, select Data > Update


4.       Select the object you want to update, then load the import file from your computer


5.       Click Next


6.       Map the field you want to update then click Map Field button


7.       Click Confirm Update


8.       Verify the data it should be updated now




Random Blogpost

BMC Atrium Single Sign-On (Atrium SSO v9.x) is an authentication system that supports many authentication protocols and provides single sign-on and single sign-off for users of BMC products. BMC Atrium Single Sign-On allows users to present credentials only once for authentication and subsequently be automatically authenticated by every BMC product that is integrated into the system.