APIs

Syndicate content

1. On the Table bar, open the table containing the field.

2. Click Settings.

3. Choose Fields.

4. There is an optional column here showing the fid's. If you don't see it, click Advanced Options, check the "Field id" checkbox and click Save.

February 5th, 2009 - 5:02 PM

If you are using the QuickBase API (say you are calling API_AddRecord using javascript to handle a form submission) and you get a sign in error like the one shown below:

<?xml version="1.0" ?>
- <qdbapi>
<action>API_AddRecord</action>
<errcode>22</errcode>
<errtext>Sign-in required</errtext>
- <errdetail>

February 5th, 2009 - 5:02 PM

Each API call accepts a parameter called "udata". This parameter is passed back in the XML response. You can create an application with a single client side XSL stylesheet that displays data differently depending on the value of the udata parameter.

February 5th, 2009 - 5:02 PM

Yes, the following two QuickBase URLS do the same thing:

6mpfsxfr?act=DBpage^pagename=pivot.xsl

6mpfsxfr?act=DBpage&pagename=pivot.xsl

Just replace the ampersands with carets.

February 5th, 2009 - 5:02 PM

QuickBase provides an extensive API for developers to access data stored in QuickBase.

For more information, visit the QuickBase developer site at http://quickbase.intuit.com/developer/

February 5th, 2009 - 5:02 PM

Create a formula field of type "Formula URL - (Link)". Let's assume the first application is a list of action items, and the related application is a list of related files. Then you need to create a formula like the one below:

URLRoot() & "db/6k7gvdyw?act=API_GenAddRecordForm&_fnm_issue_id="
& URLEncode(ToText([Record ID#]))

February 5th, 2009 - 5:02 PM

Using IE8, the easiest way to create the HTML for a QuickBase data entry form is to use the following wizard:

https://www.quickbase.com/db/6mztyxu8?act=DBPage&pagename=formWizard.html

Note: This wizard does not currently work with IE9.

February 5th, 2009 - 5:02 PM

© 1997-2014 Intuit Inc. All Rights Reserved.

Online Database VeriSign Secured Web Based Software TRUSTe Certification Online Database SSAE Audit