QuickBase to Sharepoint Sync?
So I have a lot of Data I like to keep track of in QuickBase. I have several dozen customized reports I check daily and weekly. Some of this data contains percentage scores for coworkers, averages,...
Forum Discussion
Try QuNect ODBC. This will allow you to connect it to a database application such as Access or Excel. The cost is around $200 per year and I've never had limits on data. You might need to know a little SQL to pull the data and schedule a batch file to pull it, but it can be done without too much effort.
I think they'll give you a free month trial to test it out. Let me know if you need more info.
------------------------------
Jessica Feauto
------------------------------
I think they'll give you a free month trial to test it out. Let me know if you need more info.
------------------------------
Jessica Feauto
------------------------------
It's $200 to upgrade but $500 since I don't have a previous version.
I tried the "Get Data From Web" by just using the URL to customized report, but I get this error message, "The credentials provided cannot be used for the Web source. Please update the credential type through a refresh or in the Data Source Settings dialog to continue. (Source at https://jlodge.quickbase.com/.)"
I imagine that has to do with the fact I use credentials to log into my QB account.
I saved the report as a CSG spreadsheet and it loads fine into Excel, but when I try to refresh all, it just won't refresh.
I was hoping it was as simple as that, but if it's gonna require spending $500 to $1000, I'll just deal with refreshing my browser to keep an eye on the data. I was hoping to keep updated from the spreadsheets because it allows me to set alerts in case a certain value is higher than it's supposed to be.
------------------------------
Joey Fletcher
------------------------------
I tried the "Get Data From Web" by just using the URL to customized report, but I get this error message, "The credentials provided cannot be used for the Web source. Please update the credential type through a refresh or in the Data Source Settings dialog to continue. (Source at https://jlodge.quickbase.com/.)"
I imagine that has to do with the fact I use credentials to log into my QB account.
I saved the report as a CSG spreadsheet and it loads fine into Excel, but when I try to refresh all, it just won't refresh.
I was hoping it was as simple as that, but if it's gonna require spending $500 to $1000, I'll just deal with refreshing my browser to keep an eye on the data. I was hoping to keep updated from the spreadsheets because it allows me to set alerts in case a certain value is higher than it's supposed to be.
------------------------------
Joey Fletcher
------------------------------