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...
QuickBaseCoachD's avatar
QuickBaseCoachD
Qrew Captain
8 years ago
Try this.  But I have not tested.

Export a dump to excel of the record ID and the multiselect field.  It should come out as a semi colon delimited list, actually a semicolon and a space.

Use Excel's Find and Replace  to find and replace.

Then upload to your table

BUT!  I have not tested this, so on the first upload, just upload 1 record to see that it works!  Then if all is good import the rest.
  • MikeMike's avatar
    MikeMike
    Qrew Cadet
    8 years ago
    That worked beautifully, thank you!  Quickbase even gave me a couple of warnings telling me that existing records may be updated.

    Something to note: 
    Export a dump to excel of the record ID and the multiselect field.  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 & Replace didn't care either way and worked well.

    Thanks again!
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    8 years ago
    Great, now I will know that the technique works for the future.  That find a replace in Excel is super powerful as it replaces within strings.