Filtering data to connect in a connected table

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 Quickbase to connect only those records that match the criteria you set. To set filter crieria, specify the following:

• The field you want to filter on. If you want to see all tasks with a particular start date, you'd choose Start as your filtering field.

• An operator. Operators vary according to the field type. The operator tells Quickbase how to filter the records. Example operators are: is equal to, is greater than, is greater than or equal to, and so forth.

• A matching value or a value in another field. Depending on the type of field you're filtering on and what operator you chose, you may have to type in a value or choose one from a list.

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:

• About connections

• About connected tables

• Refreshing a connected table