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, etc.. I used to use Google Suite to track this information, but now we are using Microsoft Office 365 and Sharepoint. So I've been trying to find a way to export this data live from QuickBase into Excel in Office 365. Our spreadsheets where we track and update information is in Excel on SharePoint. I've tried using the desktop version of Office 365's Excel and go into the Data and Get Data From Web and other options. I've went into the refresh options to try to refresh hourly. It won't. Is it not possible to sync them so the information in QuickBase exports and updates the data in sharepoint? I can save the data in Quickbase as a Spreadsheet CSV file and load it into Excel just fine, but it won't refresh and update. ------------------------------ Joey Fletcher ------------------------------
Google Charts pulling in Quickbase table data
I've got a use case where I want to display a google chart based on a table results, I think I'm close, but can't seem to figure it out..... Any coding wizards out there able to help? Any and all comments are appreciated!! Thanks in advance! Table results URL = https://nsk.quickbase.com/db/bqjmcc6ih?a=q&qid=20 This table has 1 field, a concatenated "Row" with what I believe to be all the correct commas, brackets, formatting, but this may be part of the problem as well (See image for sample data) My html page is as follows: <html> <head> <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script> <script type='text/javascript' src='https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js'></script> <script type="text/javascript"> google.charts.load('current', {'packages':['timeline']}); google.charts.setOnLoadCallback(drawChart); function drawChart() { var data = new google.visualization.DataTable(); data.addColumn('string', 'Fault'); data.addColumn('date', 'Fault Occur'); data.addColumn('date', 'Fault Reset'); var options = { height: 1000, timeline: { groupByRowLabel: true } }; var url = "https://nsk.quickbase.com/db/bqjmcc6ih?act=API_GenResultsTable&qid=20&jsa=1"; $.getScript(url,function(){ data.addRows(qdb_data); var chart = new google.visualization.Timeline(document.getElementById('chart_div')); chart.draw(data, options); }); } </script> </head> <body> <div id="chart_div"></div> </body> </html> But my result is a blank page. If I paste the table output to the code, and eliminate the $.getcript portion, this code loads & displays properly. <html> <html> <head> <script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script> <script type='text/javascript' src='https://ajax.googleapis.com/ajax/libs/jquery/1.7.2/jquery.min.js'></script> <script type="text/javascript"> google.charts.load('current', {'packages':['timeline']}); google.charts.setOnLoadCallback(drawChart); function drawChart() { var data = new google.visualization.DataTable(); data.addColumn('string', 'Fault'); data.addColumn('date', 'Fault Occur'); data.addColumn('date', 'Fault Reset'); data.addRows([ ['Robot Command Enable (UO1)',new Date(2020,6,16,6,31,57), new Date(2020,6,16,7,34,6)], ['Robot Command Enable (UO1)',new Date(2020,6,16,9,12,21), new Date(2020,6,16,9,16,56)], ['Robot Command Enable (UO1)',new Date(2020,6,16,9,19,34), new Date(2020,6,16,10,16,14)], ['Robot Command Enable (UO1)',new Date(2020,6,16,10,16,25), new Date(2020,6,16,10,50,1)], ['Robot Command Enable (UO1)',new Date(2020,6,16,11,56,36), new Date(2020,6,16,11,58,41)], ['Robot Command Enable (UO1)',new Date(2020,6,16,12,11,31), new Date(2020,6,16,12,49,51)], ['Robot Command Enable (UO1)',new Date(2020,6,16,13,5,6), new Date(2020,6,16,13,13,18)], ['Robot Command Enable (UO1)',new Date(2020,6,15,11,7,2), new Date(2020,6,15,11,25,55)], ['Robot Command Enable (UO1)',new Date(2020,6,15,12,19,52), new Date(2020,6,15,12,50,10)], ['Robot Command Enable (UO1)',new Date(2020,6,15,12,52,9), new Date(2020,6,15,12,56,21)], ['Robot Command Enable (UO1)',new Date(2020,6,15,12,57,11), new Date(2020,6,15,12,59,17)], ['Robot Command Enable (UO1)',new Date(2020,6,15,13,12,57), new Date(2020,6,15,13,14,48)], ['Robot Command Enable (UO1)',new Date(2020,6,15,13,15,21), new Date(2020,6,15,13,15,35)], ['Robot Command Enable (UO1)',new Date(2020,6,15,13,16,21), new Date(2020,6,15,13,16,48)], ['Robot Command Enable (UO1)',new Date(2020,6,15,13,17,41), new Date(2020,6,15,13,19,14)], ['Robot Command Enable (UO1)',new Date(2020,6,15,13,24,28), new Date(2020,6,15,13,52,15)], ['Robot Control Fault (UO6)',new Date(2020,6,16,6,32,10), new Date(2020,6,16,7,34,6)], ['Robot Control Fault (UO6)',new Date(2020,6,16,9,12,37), new Date(2020,6,16,9,16,56)], ['Robot Control Fault (UO6)',new Date(2020,6,16,9,19,34), new Date(2020,6,16,10,16,14)], ['Robot Control Fault (UO6)',new Date(2020,6,16,10,16,25), new Date(2020,6,16,10,50,1)], ['Robot Control Fault (UO6)',new Date(2020,6,16,11,56,54), new Date(2020,6,16,11,58,41)], ['Robot Control Fault (UO6)',new Date(2020,6,16,12,11,31), new Date(2020,6,16,12,49,51)], ['Robot Control Fault (UO6)',new Date(2020,6,16,13,5,7), new Date(2020,6,16,13,13,18)], ['Robot Control Fault (UO6)',new Date(2020,6,15,11,7,2), new Date(2020,6,15,11,24,21)], ]); var options = { height: 1000, timeline: { groupByRowLabel: true } }; var chart = new google.visualization.Timeline(document.getElementById('chart_div')); chart.draw(data, options); } </script> </head> <body> <div id="chart_div"></div> </body> </html> ------------------------------ Jeremy Myer ------------------------------
Is there any way to trigger python script based on any event in QuickBase?
Can you please let me know if there is any way to trigger python script based on any update in QuickBase (Master/Source Data)? Either through Quickbase action/automation/pipelines. ------------------------------ Sudhir B ------------------------------
Pipeline to import an .xlsx from a watched folder in OneDrive
Hello QB Folks! I've done a bunch of looking around, and can't see an out-of-the-box solution. I get a couple of excel files (in .xlsx) a day that I load into specially-set up staging tables in my quickbase. From there, I have pipelines moving the data into other parts of my app. I'd love to figure out how to drop the file into a watch folder in OneDrive, and have the rows loaded as-is into my staging tables. I can see the OneDrive pipeline, but it doesn't seem to have a function to process the contents of a file. ------------------------------ Malcolm McDonald ------------------------------
Syntax in sending a Text Message
So most of our new hires are all "texters", so I am trying to get it figured out. I have looked around and have a portion of it built. BUT... What would be the texting equivalent of the email subject line and body similar to below? &"?subject=INFORMATION NEEDED TO ACTIVATE YOUR CARD" &"&body="&"Welcome Aboard "&[Associate First Name]&"!" I have not been able to find anything that will create these for me ------------------------------ Hans Hamm ------------------------------
Syncing Quickbase and Outlook Contacts
Hi, looking for help with an integration. Has anyone implemented a good way to sync a contact table in Quickbase, to Outlook? Maybe using Zapier or another service? Webhooks, APi? We want to have a 2 way sync that when a contact in QB is updated or added, it will update in Outlook and vice versa. This would involve 50 or so employees. I'm thinking others have probably needed something similar. Has anyone come up with a good way to do this? Thanks for any insight, Dana ------------------------------ Dana Hauser ------------------------------
How to connect external databases ?
Hi team, I want to know about how we can connect external database in Quickbase. For example I have existing app which use existing database like MySQL or MSSql. How we can pull or fetch data from this database in Quickbase? If I create an application in Quickbase then How can I connect my existing database with QB? Do we have any connectors available ? Regards, Kat. ------------------------------ Kat Mill ------------------------------
