Filtering data to connect in a connected table

This topic refers to functionality that is not available to accounts on the Quick Base Essential plan. If the functionality described here does not match what you're seeing in Quick Base, your account is probably on this plan.

This topic describes how to filter the data you want to connect using a connected table. After you create your connected table, you can set filters on the connected table to view an even more refined subset of your data.

Filtering the data to connect

You can set a filter to limit the data that you connect from an external service, such as QuickBooks Online or Salesforce.com. Setting a filter helps restrict connected records to the ones you really care about; for example, invoices from this year, rather than all invoices.

The filter criteria that you set determines the values that the data must match in order to appear in the set of records returned; for example, only records with an Active status.

You can filter on any of the fields in your source data - not just the fields that you selected to connect. This helps you refine your connected data, without bringing unnecessary fields into your connected table.

You can set or change a filter on a connected table any time.

To create or edit a filter on a connected table
  1. Open your connected table and select SETTINGS.

  2. Click the Connection, for example, QuickBooks connection.

  3. On the Details tab, click the edit link next to Filter.

  4. Define the filter and then click Done.

  5. Click Yes to refresh your data. Your changes won’t take effect until the data is refreshed. You can refresh your data any time by clicking Refresh data.

Filtering to view a subset of connected data

Defining a filter

A filter tells Quick Base to connect only those records that match the criteria you set. To set filter crieria, specify the following:

For instance, if you want to see all tasks that are in progress, you'd choose the following:

Field

Operator

Matching value

Status

is equal to

In progress

You can set a single line of criteria, or add more fields if you'd like. Hover your mouse over the field dropdown. Plus and minus sign icons appear to the right of the field.

Click the plus sign () icon to add another line of filter criteria. Use the minus sign ()  icon to delete the current line.

Comparing a field to a specific value

To create a filter that finds a specific matching value, enter or select a value in the field that appears when you choose one of the following operators:

Field type

Operators

Text

Date/Time

  • contains*
  • does not contain*
  • is — if this is empty, the field is empty or null
  • is not — if this is empty, the field is not empty or not null
  • starts with*
  • does not start with*
  • comes before
  • comes before or same as
  • comes after
  • comes after or same as

* Notes

When you connect to Exchange or Gmail, some operators only support complete matches, not partial matches. For example, the filter "Subject contains Project" would return messages with "Project" but no variations such as "Projects" or "Projections."

For Exchange, these operators filter on complete words:

  • contains, starts with

For Gmail, these operators filters on complete words:

  • contains, does not contain, starts with, does not start with

Numeric

  • equals
  • does not equal
  • is less than
  • is less than or equal to
  • is greater than
  • is greater than or equal to

Date

Time

Time of Day

Duration

  • equals the date
  • does not equal the date
  • is after the date
  • is on or after the date
  • is before the date
  • is on or before the date

Checkbox

  • is checked (or true)
  • is not checked (or false)
Related Topics:

 

Go back      |       

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