How to automatically delete or update data from a table

  • 0
  • 1
  • Question
  • Updated 3 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 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,310 Points 50k badge 2x thumb
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.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,310 Points 50k badge 2x thumb
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...