0

Requirement:- we need to convert a multi-select picklist value into single select picklist value.if We change the Multiselect to Single .how we can avoid data loss

  • If there is record that currently have 3 picklist values, how do you want to convert it into single value? – Liron C Nov 3 '16 at 4:55
  • Yes that is the business requirement.I already Explained its not possible ,but posted for any solution/workaround. – dem Nov 3 '16 at 4:59
  • You can suggest that in case record have more than 1 picklist value, then you will put there only first value (after changing it single picklist). If it's fine, use the solution Sharvan suggest below. If it's not, require conversion logic from the person who raise the requirement – Liron C Nov 3 '16 at 5:04
0

We will be losing data if Changing from multi Picklist to any other type. It's not possible to avoid while conversion but we can do with apex data loader with minimal risk.

  1. Take a backup
  2. convert to picklist
  3. Remove multi select to single value in csv file with respect to your requirement
  4. upload into salesforce.

documentation Link

  • Now the Requirment is The Value listed First in Mulitselect for perticular record needs to be set in single Picklist after Changing to Single Picklist. Is there any option to set fist value in record when we convert multi select to single picklist.Please suggest – dem Nov 3 '16 at 6:03
  • you have to play with csv file. it's not possible in salesforce – Shravan Boddula Nov 3 '16 at 6:23

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.