Forum Discussion

ChaitaliDamani's avatar
ChaitaliDamani
Qrew Member
2 years 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
------------------------------
  • 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)
    mark.shnier@gmail.com
    ------------------------------