Forum Discussion

ChaitaliDamani's avatar
Qrew Member
8 months ago

Updating records from the Excel Spreadsheet

I have data with some 4,000 records, which I imported on QuickBase and created two tables sharing the parent-child relationship from one spreadsheet. The spreadsheet has several entries with the same ID, so there is no unique identifier for each record in the spreadsheet. On QuickBase, I have established a parent-child relationship. Hence, the parent table has a unique identifier, and the child has multiple records of a single ID in the parent record. The data gets updated every month and there is a new spreadsheet every month that will have some updates in the existing data records and some new forms. Can I find new records and updates in the existing records in the spreadsheet and import the updated data into two different tables that I have on QuickBase? Also, how can I automate the process

Chaitali Damani

1 Reply

  • Can you tell me if there is any set of fields in the child table which when cincatenated together would form a unique key?

    Mark Shnier (Your Quickbase Coach)