Changing multiple option selection to single

Options
Alison Pallett
Alison Pallett Member Posts: 1
edited July 2022 in Sales CRM #1

I have a drop down list with multiple options in. I want to amend this so that only 1 option can be chosen from the list

Comments

  • Edie Mew
    Edie Mew Member Posts: 169
    First Anniversary 5 Up Votes 5 Likes First Answer
    edited April 2022 #2
    Options

    Hi @Alison Pallett  this is absolutely achievable. It would require maybe some preparation work first before completing. It includes the below steps:

    1. Create the new custom field where the options are single option only (you may want to put a marker on it to distinguish between the two fields)
    2. Then create a filter where all contacts/orgs/people have this field completed, be sure to include the ID & the newly created custom field (single option only) when creating the filter
    3. Export this filter into an Excel spreadsheet and then migrate by simply copying and pasting across the data from the original (unwanted) field into the newly created (single option) field. 
    4. Finally when you're happy that all data is accurate, re-import into Pipedrive. It's very important you include the Pipedrive System ID as this will map it back to the data in the CRM