How to automatically delete or update data from a table

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

Good Morning

I made a system that it "insert" data every one hour from CSV to Quickbase, if you are interested, please check this.

https://quickbase-community.intuit.com/questions/58323-how-do-you-automate-import-of-csv-file-into-q...

I want to delete data automatically from the table before inserting, so only new data is in table, since I found out that there are some duplicate data.

I want to make a program that delete data automatically from the tables every one hour.

if this method is not possible, I would like to do "update" 

Thank you so much

Photo of kazuaki

kazuaki

  • 0 Points

Posted 4 years ago

  • 0
  • 1
At the EMPOWER Customer Event last year, QuickBase announced that they planned on introducing QuickBase Sync for CSV.  My personal expectation is that they will announce this in January sometime.  I suggest that you just hang tight until then and then this will be a native QuickBase feature included at no extra cost with with no programming required.
I suggest that you sign up for the early access program to QuickBase Sync for CSV.. There is a link at the bottom of this web page. http://quickbase.intuit.com/blog/2015/05/27/introducing-quickbase-sync-for-streamlined-cloud-integra...