justanotherguy
Total posts: 88
12 Окт 2015 20:45

Hi Serg,

I changed the value name of a checkbox field after records have selected it. When I search I see both options in the search. For example. I had a value where users could select their favorite color. It used to say purple. Users have made that selection that was saved in their record. I decided to change the value to read violet. New users only see this selection but when I seach records I now see Purple and Violet. I would like to mass change all the old Purple Selections to now select violet. Is there a way to do this without going through each record to make the change?

Thanks in advance for all the help.

Последние изменения: 14 Окт 2015


Sergey
Total posts: 13,748
13 Окт 2015 20:55

You cannot mass change. But for future you can use language keys to field values. For example you have Purple you could add language key PURPLE="Violet". Or better add values of fields like so COLOR_RED and then create translation.


pepperstreet VIP
Total posts: 3,837
14 Окт 2015 01:27

justanotherguy Is there a way to do this without going through each record to make the change?

NoNumber.nl DB Replacer might be helpful. Quite visual for a database tool.
(Always make backups first!!!)

Работает на Cobalt