How do I import another column of data to an already existing table?

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I've imported information into a table however i want to add another column to the table.

This column has information that needs to be imported from excel.

How do I import information to a new field that i've created in an already made and imported table?

Photo of Hannah

Hannah

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of Ⲇanom the ultimate (Dan Diebolt)

Ⲇanom the ultimate (Dan Diebolt), Champion

  • 30,434 Points 20k badge 2x thumb
To import a new column and have the values land in the right record you have to have a primary key  defined other than [Record ID#]  (say [part number] or [employee id]) that is maintained outside of QuickBase. if this is so you just import two columns of csv data:

[part number], [ new column] 

or 

[employee id], [new column]

If [Record ID#] is your primary key you can't do an updating import as your new column data has no way of associating with the [Record ID#]s which QuicKBase has previously assigned to your existing records.