Upload data from .XLSX to quickbase automatically

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered
Hi, 

I uploaded an XLSX file  with data into QuickBase to create a new app.The data in Excel file will change evry 30 min or 1 hour (new rows and update some cells ,etc.) . Is there a way where we can set up Quickbase to update automatically the app ? 


Thanks

Anis
Photo of Anis

Anis

  • 0 Points

Posted 2 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
You can read about QuickBase Sync here. http://help.quickbase.com/user-assistance/Default.html#about_connected_tables.html  it is possible to make a new table (not your existing table) and have it be updated automatically form a CSV format file which is located in a cloud service like DropBox, Google drive or Box.  But it will not do Excel format, just CSV.
Photo of David

David

  • 836 Points 500 badge 2x thumb
We created a macro on one of our spreadsheets to save a copy as csv.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
Great, so the idea situation is an automated process to upload to the cloud.  They are also in Beta testing to roll out the ability to locate the file on your own company servers as some of their big client have strict IT policies not to store data on cloud services.  If that's an issue for you, you could put in a ticket to be part of that beta program.  You cannot change the Source for a sync table once its set up.