Articles

Articles of interest to QuickBase folks

Articles

  • Using Key Fields

    By default, each table has the built-in field called RecordID (rid), that provides the unique key for that record within the table. If you want to use another field as the key field, you may do so, provided that the field type supports the Unique property, which must be checked to insure that there are no duplicates.

    October 13th, 2009 - 2:10 PM
  • Format Parameter: Structured vs. Unstructured

    One useful feature youll want to use in the API_DoQuery call is the <fmt>structured</fmt> parameter. By default the query returns are not structured. Basically, youll just get the table name, any DBVars, and the record data with the fields you specified, all with the field names, like this:

    October 13th, 2009 - 2:10 PM
  • Sample Queries

    Sample Queries

    To query a particular field:

    {'7'.XCT.'Fred'}

    To query any field:

    {'0'.OAF.'3/31/01'}

    October 13th, 2009 - 2:10 PM
  • Uploading and Downloading Files

    Uploading and Downloading Files

    QuickBase applications can support file attachment storage and file attachment access through the APIs file upload and download feature. Files are attached through a record field that has the type File.

    October 13th, 2009 - 2:10 PM
  • Uploading Files

    Uploading Files

    Files are uploaded as file attachments to a record during an API_AddRecord or API_EditRecord call. The file field you use for file attachments must be of type File.

    October 13th, 2009 - 2:10 PM
  • Downloading Files

    Downloading Files

    There are two ways to download a file.

    The first and easiest way to download an attached file can be used if you know the database ID, the record ID, the Field ID of the file field you are attaching to, and the version ID.

    October 13th, 2009 - 2:10 PM
  • HTTP API Language Reference

    HTTP API Language Reference

    This chapter provides detailed descriptions of each API call in the HTTP API.

    October 13th, 2009 - 2:10 PM
  • Order of Parameters in API Calls (XML or URL)

    Order of Parameters in API Calls (XML or URL)

    QuickBase accepts API call parameters in any order whether the call comes in as an XML POST or as a URL GET.

    October 13th, 2009 - 2:10 PM
  • Handling Special Characters for a Query Field Value

    Handling Special Characters for a Query Field Value

    What happens if you are querying for a value that has double quotes, for example, Joe B. Briggs? You need to double the quotes on each side, like this:

    Joe B. Briggs

    October 13th, 2009 - 2:10 PM
  • Querying on Dates and Times

    Querying on Dates and Times

    Notice that you can query on dates (yyyy-MM-dd) or on times in milleseconds, but you cannot query on date-time values in the standard format yyyy-MM-dd hh:mm:ss.

    October 13th, 2009 - 2:10 PM

© 2016 QuickBase, Inc. All Rights Reserved.

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