Bulk data update in Quick Base

  • 0
  • 1
  • Question
  • Updated 11 months ago
  • Answered
I have already imported data into a number of Quick Base tables from excel. These tables are relational and I had to build the relationship outside of Quick Base before importing the complete set of data. Now there is a need to add one more column to one of the tables. Is there a way I can bulk update or import values into this new column?
Photo of Manish Tewari

Manish Tewari

  • 162 Points 100 badge 2x thumb

Posted 11 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 67,348 Points 50k badge 2x thumb
Yes, but you will need to export a spreadsheet of enough columns to identify the record along with the [Record ID#] field.
The using vlookup in excel or some other method, create an excel sheet with the Record ID# field and that new data element (filed).  When you import and include the [Record ID#] field it will update existing records and not duplicate them.  Be care not to import blanks into an existing fields as that would overwrite existing data to blank. The safest way is to just import the [Record ID#] field and the new column(s).