QuickBase API Cookbook v3.

This application is a collection of small-to-medium size code snippets (recipes) that solve particular problems using the QuickBase API.

If you have written API code that solves a common problem and would like to add it to this cookbook, please send it to the author or manager of this application. Make sure your code does not include user names or passwords, and uses variables instead of table or field IDs. 

Search:

If you are viewing this application in the QuickBase Application Library and just want the contents of the Cookbook,  click here to download a zip file of the recipes.

All Recipes
 
Title
Keywords
Date Modified
 
Download file attachments from a table to a local hard drive download file 05-16-2011 01:41 PM
Run a Ruby API script without installing Ruby ruby install rubyscript2exe ocra 05-16-2011 11:53 AM
Email a report every 4 hours email report hours 04-21-2011 04:31 PM
Forward Emails to a QuickBase Table email forward table 04-21-2011 02:51 PM
Get summary records summary 11-20-2009 11:44 AM
Make a CSV file from the data in a table CSV file download 11-05-2009 01:35 PM
Find QuickBase records by running a Windows batch file find records batch windows 09-21-2009 08:59 PM
Dump the schema for a table into a file schema dump table 09-09-2009 09:29 PM
Retrieve records in JSON format JSON records 07-20-2009 10:18 PM
Use object-oriented programming to interact with QuickBase object oriented 06-12-2009 09:59 PM
Use dynamic nature of Ruby to simplify retrieving data from QuickBase dynamic ruby 05-10-2009 06:34 PM
Use shortcuts to get values from XML returned from QuickBase xml shortcut 05-10-2009 05:34 PM
Add a new QuickBase user and invite him to an application provision add invite user 05-03-2009 08:33 PM
Add/Change/Remove users from Roles add change remove user role 05-03-2009 07:36 PM
Run a pre-defined Import via the API import 05-03-2009 05:47 PM
Get a list of the users and their roles in an application users roles 05-03-2009 05:36 PM
Set the value of an application variable application variable set 05-03-2009 05:06 PM
Get the role of a particular user in a particular application user role application 05-03-2009 04:18 PM
Get date/time information about an application date time 05-03-2009 03:57 PM
Add a table to an application add create table 05-03-2009 03:25 PM
Get informaton about a specific QuickBase user user info email 05-03-2009 03:12 PM
Get the list of Roles in an application role list 05-03-2009 01:21 PM
Create an RSS feed using data from multiple QuickBase tables RSS feed 09-02-2008 07:49 AM
Download the QuickBase API Cookbook recipes to your local drive Download 03-31-2008 01:13 PM
Get the table IDs of the child tables of an application table id child application 03-30-2008 08:45 PM
Lookup a field property lookup field property 03-30-2008 06:25 PM
Copy images from web pages to QuickBase records copy image web 03-30-2008 03:19 PM
Create links to other records inside HTML text fields link wiki tag url 03-30-2008 12:43 PM
Send a file to QuickBase by dragging it onto a Windows desktop icon drag drop windows desktop 03-30-2008 10:54 AM
Get table and record values using simple REST requests REST request 03-28-2008 02:31 PM
Exchange messages automatically between QuickBase and Twitter twitter message automatic 03-28-2008 02:24 PM
Get a list of records with human-readable field values printable readable 03-26-2008 05:19 PM
Get a list of field IDs for a table field id table list 03-26-2008 04:11 PM
Get the time in milliseconds, for comparison with QuickBase record timestamps timestamp milliseconds 03-24-2008 12:02 PM
Get the name of a QuickBase table from its id id table name 03-22-2008 06:17 PM
Get the number of tables in a QuickBase application number tables 03-22-2008 04:54 PM
Test whether a string is in the format of a QuickBase database ID (dbid) dbid id string 03-22-2008 03:49 PM
Get messages from QuickBase to send to Twitter twitter message 03-17-2008 11:53 AM
Get Twitter messages into QuickBase Twitter 03-16-2008 11:39 PM
Make a slideshow in QuickBase from a folder of picture files slide show slideshow picture folder 03-14-2008 06:29 PM
Use company.quickbase.com instead of www.quickbase.com in all API calls company org 03-14-2008 01:02 PM
Display a 'running total' column in a regular Table report running total table report 03-13-2008 11:17 AM
Use Ruby code in a 'formula' field ruby formula 03-13-2008 12:17 AM
Send a file to QuickBase from the Windows 'Send To' menu send Windows explorer right-click 03-12-2008 11:10 PM
QuickBase Instant Messenger instant messenger 03-06-2008 10:24 PM
Display a report and its form on one web page report form page 03-06-2008 06:08 PM
Get the record display URL for a record display url record 03-06-2008 04:48 PM
Make a web page with report links fixed on the left side report links fixed html page 03-05-2008 05:52 PM
Get a list of the sort fields used in a report sort field report 03-03-2008 09:05 PM
Get a list of the columns used in a report column list report 03-03-2008 09:00 PM
Determine whether a field has an Average in reports field total 03-03-2008 08:45 PM
  Determine whether a field has a Total in reports field total 03-03-2008 08:28 PM
Improve the speed of multiple API requests speed performance 03-01-2008 01:39 PM
Get the list of reports for a table list reports queries 03-01-2008 12:32 PM
Get the status of the QuickBase server server status 02-28-2008 06:37 PM
List the pages in an application list pages page application 02-28-2008 06:10 PM
Edit a record, or add one if necessary add edit record 02-28-2008 11:52 AM
Retrieve one record from a table get one record 02-28-2008 11:52 AM
Get a list of the tables in an application list table name 02-25-2008 09:40 PM
Format a duration value retrieved from QuickBase duration format 02-24-2008 02:58 PM
Format a percent value retrieved from QuickBase format percent 02-24-2008 01:16 PM
Format a currency field value retrieved from QuickBase currency format 02-24-2008 01:15 PM
Update username and password in one place username password update 02-24-2008 01:15 PM
Make an intranet site ASAP that connects to QuickBase intranet site 02-18-2008 02:58 PM
Get the list of field names for a table field names 02-11-2008 08:23 AM
Get the value of an application variable application variable get 02-09-2008 12:46 PM
Use the QuickBase API with JRuby jruby ruby api 01-14-2008 12:56 PM
Connect QuickBase to Ruby on Rails rails 12-28-2007 05:54 PM
Select records using an SQL query sql query 12-25-2007 10:50 PM
Upload all the files in a folder into new QuickBase records upload folder directory 12-24-2007 06:15 PM
Find the data type of a field from its name data field type 02-14-2007 09:56 PM
Display a more readable version of QuickBase responses display print XML 02-14-2007 09:43 PM
Set a deviation field for a group of records average deviation 02-14-2007 09:06 PM
Set a percentage field for a group of records percent sum 02-14-2007 09:05 PM
Upload data directly from Excel into QuickBase Excel 02-12-2007 10:02 AM
Get records matching a regular expression, e.g. 'Name' starts with A through E match regular expression 02-10-2007 09:33 PM
Get the average of the values in a field from the records in a query average 02-10-2007 12:01 AM
Get a count of the records in a query with a value count 02-09-2007 11:58 PM
Get the sum of the values in a field from records in a query sum 02-09-2007 11:55 PM
Get the maximum value of a field from query results maximum value 02-09-2007 11:53 PM
Get the minimum value of a field from query results minimum value 02-09-2007 11:51 PM
Loop through records merged from two or more tables merge union tables query 02-08-2007 01:59 PM
Loop through records joined from two or more tables join loop multiple tables 02-07-2007 11:11 PM
Get the choices available for a multiple-choice text field choices multiple text get 02-04-2007 01:10 PM
Run API code when specific emails arrive in Outlook Outlook email API event 02-04-2007 10:55 AM
Remove all records from a table remove delete records 02-03-2007 11:20 PM
Process records returned from a query as field/value pairs hash process record query 02-03-2007 10:50 PM
Modify fields in all records matching a query modify fields query 02-03-2007 02:51 PM
Run code when records are added or modified add change event notification code 02-02-2007 12:01 AM
List all the QuickBase applications you can access list accessible applications 02-01-2007 10:31 PM
Stop sending API requests to QuickBase when an error occurs stop API requests 02-01-2007 09:58 PM
Updating the latest copy of a file in a particular Quickbase record every hour Upload update file 02-01-2007 09:37 PM
Upload a file into a new QuickBase record upload file 02-01-2007 09:27 PM
Edit data offline in a simple text file text file offline 02-01-2007 08:43 PM
Add simple records 'offline' by entering a field in a dialog box offline field entry dialog 01-30-2007 10:44 PM
Add simple records by entering a field in a dialog box field entry dialog 01-30-2007 10:39 PM
Show a message when records are added or modified add change event notification 01-30-2007 10:19 PM
Download a file from QuickBase download file 01-30-2007 08:48 PM
Loop through records and fields returned by a query loop record field query 01-29-2007 10:32 PM
Get records owned by a particular person record owner query find 01-29-2007 09:40 PM
Get records containing a certain value find query value 01-29-2007 08:45 PM
Get records added today query added today 01-28-2007 11:24 PM
Get records in an array rather than XML record array loop 01-28-2007 08:53 PM
Format a date value returned from QuickBase date format 01-28-2007 06:10 PM
Get the dbid (database id) of a 'child' table id dbid multi child table 01-28-2007 05:29 PM
Save request and response XML to a log file log debug XML 01-28-2007 05:03 PM
Show XML request/response to/from QuickBase debugging XML 01-27-2007 10:44 PM
Get the last time that anything was modified in a table table modified 01-27-2007 10:36 PM
Get the last time that a record was modified in a table record modified 01-27-2007 10:36 PM
Get the date and time a table was created create time 01-27-2007 10:33 PM
Get the number of records in a table number records 01-27-2007 09:48 PM
Making a backup copy of an application backup 10-04-2006 01:53 PM
Automatically upload CSV data into QuickBase Upload CSV data 10-04-2006 01:43 PM
Making multiple copies of a record Copy records 10-03-2006 05:28 PM
Run an API script by clicking a web link Script URL 10-01-2006 02:59 PM
Create a daily history of the changes to a table Copy records 10-01-2006 02:25 PM
Create records in table 3, using data from tables 1 & 2 Create records automatically 10-01-2006 12:05 PM
Access QuickBase from a command line instead of a browser Command line 10-01-2006 11:37 AM
Report Name *
Description
Reports and Charts Panel
Each table has a panel listing its reports and charts, organized in groups.
Please wait while your new report is saved...
Field label
Column heading override
Justification
What does auto mean?
Fields in:

Fields to Extract:
Name for the new table:
Items in the new table are called:

When you bring additional fields into a conversion, Quickbase often finds inconsistencies. For example, say you're converting your Companies column into its own table. One company, Acme Corporation, has offices in New York, Dallas and Portland. So, when you add the City column to the conversion, Quickbase finds three different locations for Acme. A single value in the column you're converting can only match one value in any additional field. Quickbase needs you to clean up the extra cities before it can create your new table. To do so, you have one of two choices:

  • If you want to create three separate Acme records (Acme-New York, Acme-Dallas and Acme-Portland) click the Conform link at the top of the column.
  • If the dissimilar entries are mistakes (say Acme only has one office in New York and the other locations are data-entry errors) go back into your table and correct the inconsistencies—in this case, changing all locations to New York. Then try the conversion again.

Read more about converting a column into a table.

Show fields from Show fields from Show fields from a related table