How can I make a global type change?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
I have several records with capitalization inconsistencies that I would like to correct. However, they are in a multi-select field where other options are selected so I cannot do a grid edit copy/paste. How can I make a global type change? 

I would like to change  ASR (Not Legacy)  to 
ASR (not Legacy)
Photo of Stephanie


  • 676 Points 500 badge 2x thumb

Posted 3 years ago

  • 0
  • 1
No problem,

Make a report with the columns of [Record ID#] and the [multi select field] and export to Excel. 

The Excel column will be the multi selected choices delimited by a semi colon ;

Use Find and Replace to do your Global change.

Import back into your app.

You may want to test this fist on a copy of your app.  I just tried this myself and it worked fine.  The Excel Find and replace is super powerful.
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,224 Points 20k badge 2x thumb
You can do it within QuickBase with script using regular expressions. See:

What is the "Clear the Swamp" Technique?