Expand all | Collapse all

Bulk data update in Quick Base

  • 1.  Bulk data update in Quick Base

    Posted 06-18-2018 04:11
    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?

  • 2.  RE: Bulk data update in Quick Base

    Posted 06-18-2018 12:56
    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).