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

Question

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 possible values, so it has left some invalid values.

The old value = "Customer Services"
The new value = "Customer Service"

The field does hold other values due to it being Multi-select text, so some records may have something else like "Staff", "Customer Services", "Finance" - it's not always the only value in the field.

What do I need to do to bulk change the values in these records?

davidhawe · Answer

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 · Answer

Thank you for your reply. &nbsp;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. &nbsp;Is this because it's a Multi-Select?

davidhawe · Answer

You may be right that it is because of multi select.

quickbasecoachd · Answer

Try this. &nbsp;But I have not tested.Export a dump to excel of the record ID and the multiselect field. &nbsp;It should come out as a semi colon delimited list, actually a semicolon and a space.Use Excel's Find and Replace &nbsp;to find and replace.Then upload to your tableBUT! &nbsp;I have not tested this, so on the first upload, just upload 1 record to see that it works! &nbsp;Then if all is good import the rest.

mikemike · Answer

That worked beautifully, thank you! &nbsp;Quickbase even gave me a couple of warnings telling me that existing records may be updated.Something to note:&nbsp;Export a dump to excel of the record ID and the multiselect field. &nbsp;It should come out as a semi colon delimited list, actually a semicolon and a space.This was actually just a semicolon, no space:Staff;Customer Service;Finance _But Excel Find &amp; Replace didn't care either way and worked well.Thanks again!

Forum Discussion

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

Related Content

Copy Single Table from One App to Another

Moving Fields from One Table to Another

Many parent records on a single child record

Modify multiple rows within the same group using Single Record ?

Changing/setting record owner