Plan availability | Enterprise Scale plans only |
Permissions |
|
Platforms | Web/Browser, Mac app, Windows app |
What is an admin panel sync?
Airtable’s admin panel sync lets admins bring metadata information from an org or org unit into an Airtable base. This can help your admins use the full power of Airtable and Omni AI to operationalize and automate the various workflows it takes to manage an organization’s Airtable instance at scale.
Enabling or disabling admin panel syncing in admin panel
Note
You will need admin permissions to adjust the setting to allow admin panel syncs in your org’s bases.
Navigate to https://airtable.com/admin.
Click the Settings tab.
Click the Integrations & development tab.
Scroll down to the “Block admin panel sync” setting.
Click the > symbol to the right of the setting.
If your organization uses the Enterprise Hub feature, then you will be able to toggle “On” or “Off” access to any individual units’ ability to sync admin panel metadata.
Adding an admin panel sync to an Airtable base
Navigate to the base where you want to create the admin panel sync or create a new base.
Click the + symbol next to your list of tables.
Then, under “Add from other sources,” click the XX more sources… option.
From the window that appears, select Airtable admin panel.
The next portion of the setup process will depend on whether your organization uses the Enterprise Hub feature:
Enterprise Hub - Click the drop down menu to select the individual “Org unit” you want to sync into the base.
Non-hub enterprises - No dropdown will appear and you can move onto step 6.
Click Create tables.
Note
Larger organizations or org units may take a few moments to initially sync since there are multiple tables and large sets of metadata to sync into the base you are creating.
Understanding admin panel synced tables
After setting up and creating the tables that are synced to your admin panel instance, multiple tables will be created. You’ll find more about what each subsequent table contains below:
Users
Groups
Workspaces
Bases
Interfaces
Org units (Will only appear when your organization uses Enterprise Hub and the admin panel org unit selected in step 5 above is the “Root” org)
“Users” table fields
User ID
First Name
Last Name
Email
Source URL
A link to the individual user detail page in admin panel. Admin permissions are needed to access these pages.
Seat Type
Seat Upgraded
Date and time
Seat Upgrade Event
Status
Account Type
Admin
Check means “Yes” the user has admin permissions
Last Active
Email Verified
Check means the user’s email is verified
SSO Required
Two Factor Auth Enabled
Joined - Date and time
Claiming Org Unit IDs
Enterprise Hub only and each org unit the user belongs to is separated by a comma.
Cost Center (SCIM)
Department (SCIM)
Division (SCIM)
External ID (SCIM)
Organization (SCIM)
Title (SCIM)
Manager Display Name (SCIM)
Manager Value (SCIM)
Org Units (Via Admin User IDs)
Groups
Workspaces (via Owner User IDs)
Workspaces (via Collaborator User IDs)
Bases (via Collaborator User IDs)
Interfaces (via Collaborator User IDs)
Interfaces (via Portal Collaborator User IDs)
“Groups” table fields
Group ID
Name
Created
Date and time
Org Unit ID
Member User IDs
Member count
Source URL
Seat type
Seat type updated
Date and time
Workspaces (via Collaborator User IDs)
Bases (via Collaborator User IDs)
Interfaces (via Collaborator User IDs)
“Workspaces” table fields
Workspace ID
Name
System
A "system" workspace is one that is managed by Airtable. We use this to show where the enterprise managed apps / components library feature is leveraged.
Org Unit IDs
Owner User IDs
Collaborator User IDs
Collaborator Group IDs
Created
Date and time
Source URL
Bases
“Bases” table fields
Base ID
Workspace ID
Name
Created
Date and time
Row Count
Sandbox
Source URL
Collaborator User IDs
Collaborator Group IDs
Interfaces
“Interfaces” table fields
Interface ID
Base ID
Name
Created
Date and time
Source URL
Portal Collaborator User IDs
Collaborator User IDs
Collaborator Group IDs
“Enterprise Org Units” (Enterprise Hub only)
Org Unit ID
Name
Default
Admin User IDs
Created
Date and time
Source URL
Groups
Workspaces
Limitations and considerations
One-way syncing only - You cannot make edits from the Airtable base. Any edits will need to be made by users with admin permissions within your organization’s admin panel.
If an admin turns off the ability to sync admin panel metadata from the “Settings” page, then any existing syncs will stop syncing with an error.
New syncs will be prevented from being created.
We will NOT delete any previously configured tables.