Forum Discussion

bratnapandey's avatar
bratnapandey
Qrew Member
22 days ago

Importing data in Tables

Hi, 

I have a table and existing fields with data. I need to add  few more fields in my existing QuickBase table . When I tried importing new fields and saw it imported in tables but with new records . But , I needed it to be based on existing unique fields,  new fields should get imported. Later, I downloaded the data in excel and added new fields in it and tried but it did not work as expected. During import, Merge field by default shows record ID , but this is not changing as per unique records based on our table. Please help to get rid of this issue . Thanks, BR

Import fields
  • Delo's avatar
    Delo
    Qrew Trainee
    21 days ago

    When you import, you need to include a column for the existing record IDs in order for it to merge on those record IDs.  I typically download the existing records, only include the record ID and any new fields I want to add, and then importing using the Record ID as the merge field.  Also, you can use another field to merge on, as long as it is marked in the fields settings as having unique values.  Here's a link to Quickbase's help article for importing data as well:  Importing Data From Excel Into Existing Apps.

    Thanks!

    Heather D