Quickbase

My Apps

New apps will be added to your account close

Create your own free Quickbase app

Quickbase Exchange has hundreds of free apps for any business process.
It's simple to get started and you don't need to be technical to do it.

Project Management
Customer Support
Sales & CRM
Marketing

Team Management
Human Resources
Information Technology
Industry-specific solutions

Find an app in Quickbase Exchange

We need to check with your admin first...

We know you're eager to create your first app-but your account settings don't let you create apps yet. We've asked your account admin to allow it, and you'll get an email from us when you can.

Prefer a more hands-on solution? Can't wait? Try a 30-day free trial, and get started creating apps immediately.

Build a new app from scratch Import a spreadsheet to create a new app

Start a trial

Quickbase is a web-site that lets you select, customize, and share online workgroup applications. The application you are using right now is powered by Quickbase.

Chances are that your organization has purchased the Quickbase service, in which case you might be able to build and deploy your own web application for little or no additional cost.

You have permission to create your own web applications.

To find out more about Quickbase, visit our web site.

Terms of Service

QuickBase Support Center

Manager: Ritchie Almonte

Company:

For which table?

Formula Functions Reference Sample Formulas Images & Attachments

Home

Prev | Next

Function Details

Category

Queries

Function Name

GetRecords

Arguments

(Text q)

Result Type

Record Collection

Explanation

Returns records matching the criteria set by query q from current table. Use this formula to obtain record list for GetFieldValues.

Note that queries within this formula use API query syntax.

Examples

GetRecords (�{3.GT.0}�) returns all records in current table for which the field with id 3 has value greater than 0.

Sample Problems and Formulas

More Examples

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

a table related to ""

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.

Client Performance Report

Network latency: ()

The time taken for page load once the page is received from the server:()

The total process of navigation and page load: ()

From inline js at page top..
        .. to the time until docready:( s)
        .. to the time until window load begins: ( s)
        .. to the time until window load ends: ( s)

Quickbase will send a report of the events currently displayed on your calendar.
Email addresses



		Don't show me this message again