Hi Qunicy,
So this is a Quick Base to Quick Base sync or is this data you are updating from a Sync to CSV from another service? I know your data is starting in an outside service but want to be clear how Sync is bringing it over. Most likely what is happening is each time you are importing in your Key field for that table is causing records to be overwritten. There are two ways to alter this, one way is to make the key include the date so that every week it would naturally update and QB would identify it is a new record. For example if each record used an invoice number like 101, 102, 103, etc. My records that I'm bringing in every week would update those with the same invoice number instead of making new records since QB recognizes them as belonging together, I could alter that by making sure my data coming in used a Key of 101-1/1/2019, 101-2/1/2019, etc so that each import is unique because of the date. If it is coming in as a CSV from another service you can do this by recreating the Sync table and selecting a composite key of your current key and a Date field to help tell them apart.
The other option would be to create an Automation or Action on the Sync table so that every time a record is Added or Modified it would simply add that record as a new record on another table. This way as each record changes each week in the Sync table all that data gets captured and pushed to a manual entry table as a fresh record, so that each version is stored even if they Sync updates. I hope this suggestion is helpful Quincy.
------------------------------
Evan Martinez
Community Marketing Manager
Quick Base
------------------------------
