>
I wish you could, but there is no API for that.
Come on now don't be ridiculous.
Be the API you want to see.This example below has two tables
Source and
Destination. The
Source table has 20 records (which you can't modify) consisting of fields
[Category],
[Item], and
[Cost]:
Source Records List Allhttps://haversineconsulting.quickbase.com/db/big4sysbf?a=q&qid=1The
Source table has this summary report:
Source Summary Reporthttps://haversineconsulting.quickbase.com/db/big4sysbf?a=q&qid=5You can
purge all the records in the
Destination table by clicking on the appropriate link shown on the application dashboard.
Summary Report to Table Import Application Dashboardhttps://haversineconsulting.quickbase.com/db/big2cgfyvIf you then click on the link labeled "
Import Summary Source Report Into Destination Table" on the application dashboard, the data in the summary report will be newly imported into the
Destination table.
Here is the code:
DoIt.js User Defined Pagehttps://haversineconsulting.quickbase.com/db/big2cgfyv?a=dbpage&pagename=DoIt.jsPastie Databasehttps://haversineconsulting.quickbase.com/db/bgcwm2m4g?a=dr&rid=225In a nutshell here is what the script does: Using a utility function
iframeLoaded(id, url) an
<iframe> is loaded into the current page (the
Source table dashboard) and is
hidden from view. The url specified is the
Source table
summary report. This function returns a jQuery
promise which will cause other code to execute when the promise resolves (ie when the
<iframe> loads). When the promise resolves, the code reaches into the contents of the newly loaded
<iframe> and extracts the tabular data from the summary report, converts it to a blob of
csv data and posts it into the
Destination table using
API_ImportFromCSV. This is all done in about 50 lines of simple code.
If you grock what is going on, you can see that this same technique can implement
any custom API you can dream up by ripping data out of any and all QuickBase pages on the planet that you have access to and returning the processed data in any format you want through the use of a promise.
Never let is be said that "there
is no API for that". There is nothing but API.