ChaitaliDamani
2 years agoQrew Member
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
------------------------------