Looking for help with my base. I want to automate importing a csv on a schedule into Airtable. Currently, I have to delete all of the records in my table, export and import a new csv from NetSuite, and then the rest of the base does the work. How do I automate this? My goal is to have this run 3-4 times daily.
I think I will have to use scripts. The delete record is necessary because if I try to import and merge records, the records duplicate because of the linking from table to table. And my knowledge of this isn’t perfect either as I did not design/build the base.