To add a connected table:
-
Name your connected table
-
Open the Quickbase app you're adding a connected table to.
-
From the sidebar, select New Table and then select Using connected data.
-
Name the connected table and select an icon to represent the table.
-
Select the data source to connect
-
Select the source you want to connect to and enter the information required for Quickbase to connect to your data. This may vary, based on the source. For most cloud apps, you’ll be prompted for your user name and password, while for CSV files, you’ll create a folder and add your file.
-
Select a set of records to connect, for example, Opportunities.
Depending upon the service, you can choose from ready-to-use collections of the most commonly requested data sets, Optimized for use with Quickbase, or if you're an expert user, you can select a table, as displayed directly from the service’s API.
Either way, after you a select a set of records, we’ll show you the available fields, so you can connect just what you need. In most cases, an Optimized data set is the best choice.
-
Select fields
-
Select fields on the left and drag them to the right to include them in your connected table. You can use keyboard shortcuts to move fields.
-
Arrange the fields in the order that you want to display the columns in your connected table and then click Next.
-
Set a filter and choose refresh options
-
Define a filter to limit the records that you connect. For example, connect only invoices from this year, rather than all invoices.
-
Select refresh options to define when and how to refresh the connected table.
Refresh your table any time by selecting
Refresh data in the page bar.
Your connected table displays in the sidebar with the connected icon. It may take a moment for Quickbase to display all the records in your connected table.
Connected fields display the connected icon in the Field Settings page. You can add or delete fields and change the filter and refresh schedule at any time.
You have a connected table — now what?
You can use connected data in your workflows and build reports across all your data from within Quickbase.
Add fields, create relationships, and configure permissions as you normally would. Create lookups and summary fields and use connected data in your work flows, reports, and home pages.
You can add more fields to your connected table or delete fields. Like all Quickbase tables, connected tables automatically include 5 built-in Quickbase fields: Date Created, Date Modified, Record ID#, Record Owner, and Last Modified By. When you create a connected table, Quickbase automatically identifies a unique field to ensure accurate update of your data later.
Check out What can I do with connected data? for some ideas.
Note: You can’t add connected fields to Quickbase tables that are not connected tables.
Learn more about connecting to: