How do you change existing multi select option values?
How Do I?
We have a site with ~1k entries that use a few Multi Select fields. We’re using the Populate Manually option for the list of values for each. We have some changes we need to make to the options. Those options are stored in the db as the text of the option, and changing the option will result in an error if an entry is edited and the option is changed. Does anyone have a reliable way to change the options, and ideally the entries, without find and replace in the database?
Not per say but I’d look at adding a new field based on Value/Label pairs, get the new field populated, the switch over template tags.
does the Value / Label pairs have a similar issue? It seems if I keep the Value the same, I can change the label. But, does that become cumbersome or “disconnected” if things change a bit more significantly?
Man this seems like deja vu
was there a message i missed?
no I feel I’ve been faced w/ something similiar
so an option might be “NJ” (already stored in the database). And you need it to be “New Jersey”. ANd if you make that change, EE will complain because prior data has ‘NJ’ but you’ve just changed to “New Jersey” ?
(because you’re from there?)
Using value/label pairs you could keep the values the same but use any old label you want - you can change labels without affecting templates directly, if you use labels in templates they’ll simply output whats there in the front end and change if you modify them.
There are also two find-replace options in EE (as in you don’t have to do a database query). One is in utilities and the other is in Pro Search.
The Find and Replace works on multi select fields? Would I change the field first, or do the find and replace? (I can also test this out)
And thanks for the rec!
that worked perfectly, @hopstudios! thanks so much for the idea!