Forum Discussion

ManishTewari's avatar
ManishTewari
Qrew Trainee
7 years ago

Bulk data update in Quick Base

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?
Tables and fields
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    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).