Connecting to Quickbase Admin Console

Access to this feature can change based on your Quickbase plan. Learn more about feature availability and plans in Quickbase capabilities.

Create a connected table to access data about your realm's users, apps, and user tokens from the Quickbase Admin Console. You can also add access information (users to apps), which will allow you to create a relationship between the users and apps data sources so you can create reports on which apps users have access to.

Bring the data you want into your app and refresh it based on a schedule you set, or any time, on-demand.

To connect to the Quickbase Admin Console, you'll need the following:

• User Token: This layer of security is required. The user token being used here must be that of a realm admin in the target URL (see below). Realm admins can create a user token in My Preferences.

• Quickbase URL: Locate the Quickbase URL in the browser. For example, https://yourcompanyname.quickbase.com.

Then:

1. Add a new connected table and select Admin Console as the data source (step 2).

   • If you're creating a new Admin Console connection, enter a connection name, the Quickbase URL, and the User Token.
   • If you already have an Admin Console connection, select it from the options shown.
2.  Select one of the following sets of records:
   • Access: Allows you to bring in both users and apps information so you can report on which apps users have access to.
   • Apps
   • Connected Tables
   • Pipelines
   • Users
   • User Tokens

   Note

   If a connected table for a set of records has already been created, it will state the app where that table resides and the connection owner.

View, test, or delete your connections

To view details about your connection and test, change, or delete connections, click the user dropdown on the Global bar, then click My preferences. Your connections display in the My Connections area.

View connected table details and history

To view Details about your connected table, including the connected service, connection owner, connected fields, filter, and schedule for the connected table, access the data connection settings in Table Settings. You can also view a History of recent refreshes and edit the connected table filter, refresh schedule, or switch to use a different connection, if necessary.

Calculations used in displays

Any conversions of the bytes in a connected field need to use base 2 (binary, 1024) and not base 10 (decimal, 1000).

Limits

• There is a limit of one Admin Console connected table for each type.
• Connected tables using the Access source cannot be synced hourly.
• Deactivated users aren't included in the results of the Admin Console Users and Access sources. Denied users aren't included in the results of the Access source. However, connected tables where the connection owner is denied or deactivated are included in the results of the Connected Tables source.
• If a connected table (destination table) has been created in an account that is now inactive, it isn’t included in the Connected Tables results.
• The source fields only apply to connected tables when another Quickbase table is the source. For example, the source fields will be empty if the source is Salesforce, QuickBooks, or Gmail.

Fields available in the Admin Console Connected tables

The following fields are available in the Admin Console Connected tables.

Related topics:

• About connections

• About data connection details

• Adding a connected table to your app

• Refreshing a connected table

• Testing a connection

• About connected fields