Quick Base Limits

This guide provides the most commonly referenced limits for Quick Base. Quick Base may have other limits not documented here, and limits may vary depending on your organization and Quick Base plan.

Feature Area

Limits

APIs

You can group a maximum of 100 filters in an API_DoQuery call using OR and AND.

Maximum size of XML responses for API calls = 150 MB.

API_Authenticate calls have a time limit of 6 months (this applies only to new tickets initiated on or after January 21, 2018)

Actions

Number: You can create a maximum of 10 actions per table.

Size limit: The HTTP message sent cannot be greater than 4MB. If the size is exceeded, the message is not sent, and the app manager receives an alert and email notification.

Rate limit: For any app, a maximum of 10 HTTP messages can be sent per second. If the rate is exceeded, subsequent messages are not sent, and the app manager receives an alert and email notification.

Note: Actions and Webhooks limits are the same.

Apps

Maximum size of the total attachments when you copy an app = 75 MB.

App variables

A variable's value is always treated as Text within a formula, unless you convert it to another data type using formula functions (such as(ToDate()).

Authentication

By default, authentication tickets expire after 720 minutes (12 hours). You can change this using the API_Authenticate call; you can set the ticket's duration to a different value.

Branding

Maximum number of characters used to customize a header, footer, and sign-in message = 3,800.

Connected Tables (Sync)

Maximum age of events kept in a connected table's history = 30 days or, if none in the past 30 days, the most recent successful refresh.

Maximum number of minutes before a refresh times out = 20 hours.

Maximum number of automatic retries for scheduled refreshes = 3 (once after 2 minutes, once after 10 minutes, once after 30 minutes)

Maximum number of cells you can import when you create a connected table = 1,000,000,000 (one billion). Cells are calculated by multiplying the number of records by number of fields.

Maximum number of fields in a table you can sync = 400.

A QuickBooks Online company account can have only one authorized OAuth connection at a time from a Quick Base app. If you have a connection to a QuickBooks Online company and create a second one, the new connection is recognized and the old one expires.

Cross-app relationships

When you create a relationship to a table in another app, the relationship only appears in the child table's Reference list.

Dynamic filters

Maximum number of dynamic filters in a report = 5

Maximum number of values shown for dynamic filters = 60

Dynamic filters configured for a report may not appear for a variety of reasons:

  • If you're using the Use the dynamic filters defined in default report settings option for dynamic filters on that report, then the fields used as dynamic filters must appear in the first ten fields in your report. If this isn't the case, change the order of report columns.
  • If a report contains no records, the dynamic filters will not appear.
  • If a field has a value longer than 512 characters, dynamic filters for that field will be disabled and a message will appear to that effect.
  • If a field has 61-200 values, some values will display, and the last item in the list will be an All Choices link, which opens a dialog with all the choices available for that field.
  • If a field has over 200 values, it will display with a message that there are too many values to use for filtering. If all the filterable fields have too many values to display, you are directed to a search page so you can search for and display a subset of your data.

Dynamic form rules

Maximum number of unique derived fields for all the dynamic form rules in a form = 20

Derived fields are calculated based on the values in other fields on the form, such as Formula fields, Summary fields, and Reference fields.

Email, including automated emails

You can't email charts, map reports, or grid edit reports.

You can't subscribe to chart reports.

You can only send subscriptions and reminders to the number of registered users of an app per table per day, with a cumulative limit of 4,000.

Maximum number of email addresses Microsoft Internet Explorer can have in a mailto link = 100

An HTML email notification can have a maximum of 400,000 characters before it is truncated (the length of the entire HTML message, not just the number of characters in the body of the message).

File attachments

Maximum number of revisions for a file attached to a table = 100.

Maximum size of file attachments is 100 MB.

Max total size of file attachments allowed in an app being copied = 75 MB.

Forms

Max number of forms per table in Quick Base Essential plan = 1

Maximum number of items in a reference field dropdown before the record picker displays = 1,000

Home Page

Maximum number of widgets per row on an app home page = 3

Maximum number of reports on an app home page = 9

Maximum number of app home pages per app in Quick Base Essential plan = 1

Import

Maximum number of records when importing into a User field = 10,000

List User field

A user can select a maximum of 20 choices from a List - User field.

Map reports

You can't print or email Map reports.

Multi-select Text fields

Multi-select Text fields can contain a maximum of 100 choices. Each choice can contain a maximum of 60 characters.

When using a multi-select field, you can select a maximum of 20 choices.

My Apps

Lists 100 apps. After you access 100 Quick Base apps, the apps you used least recently are removed from the list.

Page tokens

If you enter data on a form and leave the form open for more than 60 minutes, you'll get a page token error.

Passwords

If your account doesn't have its own realm, the minimum password length = 8.

A standard password in a realm has a minimum of 7 and a maximum of 64 characters. You can adjust these default settings in Realm Policies.

A password reset link expires after 90 minutes.

Printing

Maximum number of records in a printed report = 500

Query filters

Quick Base allows only 100 initial filters.

In the API, a query can have no more than 100 parameters.

Realm settings

By default, a user is locked out of Quick Base for 10 minutes after 10 unsuccessful login attempts. You can change this in Realm settings.

The default session timeout is 720 minutes (12 hours). You can change this on the Realm Policies page.

Reference fields

On forms, Reference fields and Reference Proxy fields typically open a dropdown when a user clicks on them. However, if the Master table contains 1,000 records or more, a record picker will display instead.

Reports

When a user creates a report, if they choose a Format in the Options section other than Normal, the maximum report size is 25MB.

Maximum number of records that are plotted in a Map report = 100 (as sorted according to the report)

Maximum number of reports or charts on an app home page = 9

(mobile site) Maximum of reports on the mobile dashboard = 20

If a report will take longer than 30 seconds to run, it will time out.

Search

If the default report on a table’s home page contains more than 10,000 records, and the table’s home page is set to show the default report, Quick Base will display the Advanced Search form.

If you search for something in a table or report, and your search term is not found within 13 seconds, the search times out.

Summary fields

If a relationship’s Reference field is a formula, you can’t create additional summary fields in the relationship.

You can’t summarize Date/Time fields.

Tables

Table names are limited to 256 characters, including spaces.

There are no hard limits on the number of rows or columns a table can have. However, a single table cannot exceed 500 MB. (This may vary according to your service plan.)

The amount of space each record uses depends on several factors, such as the number and types of fields in the table. Consult Quick Base Help for details on the data space consumed by each field type.

(mobile site) Maximum number of tables on the dashboard = 20

User invitations

When you invite an unregistered user to an app, the link stays active for 180 days.

You can invite or import a maximum of 400 users at one time to an app (10 users for a trial user).

Webhooks

Number: You can create a maximum of 10 webhooks per table.

Size: The HTTP message sent cannot be greater than 4MB. If the size is exceeded, the message is not sent, and the app manager receives an alert and email notification.

Rate: For any app, a maximum of 10 HTTP messages can be sent per second. If the rate is exceeded, subsequent messages are not sent, and the app manager receives an alert and email notification.

Note: Actions and Webhooks limits are the same.

 

Go back      |       |   

© 1999-2018  QuickBase, Inc.  All rights reserved.  Legal Notices.