Forum Discussion

MikeMike's avatar
MikeMike
Qrew Cadet
8 years ago

How to bulk change one value to another in a single field?

I have a field in a table where I need to bulk change a specific value to be a different value.  The field is populated through a Multi-select Text and we have updated one of the values in the list of...
DavidHawe's avatar
DavidHawe
Qrew Trainee
8 years ago
If you want to do all of them, run your "List All" report.  Then at the upper right, below the table ribbon will be the word More with a caret to its right.  Click on the caret and one of the options should be "Search & replace in this report. 

Choose the field then the from an to fields and click Next.  Then it will tell you how maby records will change and when you click Ok it will change them
MikeMike's avatar
MikeMike
Qrew Cadet
8 years ago
Thank you for your reply.  I actually found that option after I posted my question, however the field I want to update is not given as an option in the drop-down list of fields.  Is this because it's a Multi-Select?