Ability to Consolidate options in Custom User field choices

[Stuart Wright]

Over time, the options for custom user fields may need to be changed.
I need to consolidate serveral separate options in a specific field in to one, new option.
For example, I want to consolidate the following ID & text choices
4se MG4 SE SR
4selr MG4 SE LR
4tlr MG4 Trophy LR
4txr MG4 Trophy ER
4s MG4 Standard
in to mg4 MG4.

And the following ID & text choices
zsse ZS EV SE
zsselr ZS EV SE LR
zst ZS EV Trophy
zstlr ZS EV Trophy LR

in to zsev ZS EV.

My idea is to, in the Custom User Field Choices section, add a tickbox to all the choices and a button at the bottom (which becomes visible when more than one tickbox is selected) Merge to new choice.

When that button is pressed, a modal opens showing a new choice ID and text. When the user enters a new choice (must be unique) and text, a Save button becomes enabled. A Cancel button closes the modal.

When the user clicks Save, a confirmation message appears stating that the selected choices will be deleted and the new choice will replace them.

When the user saves,

1. a new record will be added for the new custom field choice
2. for each user, in the table storing the custom vield values, the records for the selected choices will be deleted and a new record added for the new choice
3. the records for the selected choices will be deleted

When the process is finished, the custom user field page refreshes showing the new choices (the selected ones deleted and the new one added).

I hope this makes sense. Maybe there is a better way of doing it.
But currently there is no way to consolidate custom user fields.
Hopefully a zillion people will like this idea.

 

[benFF]

For what it's worth, I'd use it to merge:

Dark blue
Light blue

Into

Blue

(along with a few other colors that no longer need the split)