Changing dropdown field from multi-select to single select

[MarshallCo]

Hi all, This is just a "play-it-safe" clarification question. I am currently needing to change a dropdown field from multi-select to single select. I'm working on cleaning up the past data so that only one choice is chosen for the field. Basically, I need to be able to group and chart the field cleanly. When I change the field from multi-select to single select, I won't lose any of this past data, correct? Thanks! Marshall Marshall Comden Plantronics, Inc.

[William--]

Hi Marshall, I recommend in these types of scenarios that you try it out in Preview to see what exactly happens with your data when you make changes to existing fields. In this case, you won't lose any historical data by changing a field from multi-select to single-select. Any old objects that still have multiple values selected will display the selected values delimited by a comma. Users can still edit those values, but will only be able to select a single value. You can also then be able to group by that field. The Grouping will treat objects that have multiple values as a unique value based on its combination of selections. For example: Option 1 Option 2 Option 3 Option 2, Option 3 Option 1, Option 2 Option 1, Option 3 Overall I've found it to be a pretty seamless transition and am really happy to be able to change the behavior/display of existing fields. Hope that helps! William English T-Mobile