Resetting 'daily orders' and saving it to external a external database help

Hi there,

I have this problem: We’re making a multi vendor platform where we want to give the vendors a real time view of orders.

Then we want to: Reset the ‘counter’ every day and save it to a external database, under the respective day and under the respective vendor.

What tool would you use?
I can’t seem to figure out how airtable can create new days automatically…