Here is the exerpt from QB online help in case anyone else needs it!
Connect to a folder with multiple files
For CSV-connected tables, you can sync data from files dropped into your CSV folder from multiple sources, like invoice data from different vendors. Or, suppose your order management system outputs multiple CSV files every hour. You can ensure each of the files will be synced to your connected table.
Here's how it works:
If you choose Make my table match the latest CSV file, Quick Base only connects to the file that was uploaded last (according to the file's time stamp). Any other files in the folder are ignored.
If you choose Keep everything in my table and add new records, Quick Base connects to the files one at a time, starting with the oldest file and proceeding to the latest (according to the time stamp of the file).
Quick Base will process a maximum of 10 files in a single refresh. After each file is read, Quick Base moves it to the Done folder. (Files in the Done folder have a timestamp appended to the filename). New records are added to your connected Quick Base table, and records with matching refresh keys are updated. No existing records are removed from the Quick Base table even if they are not in the connected files.