Users - Airtable enterprise admin panel
  • 24 Aug 2024
  • 8 Minutes to read
  • Dark
    Light
  • PDF

Users - Airtable enterprise admin panel

  • Dark
    Light
  • PDF

Article summary

Plan availability

Business and Enterprise Scale only

Platform(s)

Web/Browser, Mac app, and Windows app 

Related reading

Airtable terminology

  • Admin panel - A centralized set of tools to help admins manage their organization’s Enterprise account. It's a designated surface that includes ways for admins to view and manage users, groups, reports, bases, and more. It is not visible or available to non-admins.

Admin panel Users page overview

The Users page of the admin panel lets Airtable admins manage and view information about Airtable usage focusing on users within their organization.

User page overview

  • The admin panel allows you to view the total number of active users associated with the organization’s Enterprise plan including external users:

    • A breakdown of users by license type 1

    • Pending user invites

    • A list of all of the users in their organization

    • The name and email address of each user

    • Additional user details in a separate window

    • Identify the user as Internal/Provisioned (no tag displayed), External, Admin, or Deactivated

    • The last date of activity for a particular user 2

    • When the user joined

    • The seat type for each user  3

    • A cost center column for accounting purposes 

    • The share link access level of a user 4

NOTE

1 This header will not be shown for organizations that have not renewed their Airtable contract as of November 2021. 2 Last activity is updated when a user takes a qualifying action in a workspace owned by the enterprise. 3 Organizations who have not yet signed a new billing contract with us will only be able to see whether the user is billable or not. 4 This column will not be shown for organizations that have not renewed their Airtable contract as of November 2021.

Users page actions

  • Invite new user actions:

    • Search, sort, and filter results in various ways

    • Download a CSV of the list of users being displayed

    • Edit the email of a user

    • Sign the user out of all sessions they are currently logged in to

    • Revoke a user’s admin access 1

    • Deactivate a user 2

NOTE

1 An admin cannot revoke their own admin permissions. 2 An admin cannot deactivate their own user account.

How to read the Users numbers in the Users page

The number shown in the admin panel's "Users" tab represents the total number of users that can access your organization's content, including users managed by your organization, deactivated users, and external collaborators.

The number displayed under the "Name" column shows the number of users that match the current filter or search query. This number doesn't always match the number shown on the "Users" tab because the page, by default, shows only active users. Apply any applicable features to confirm both numbers are accurate.

“Active user” overview

Active users can log in and access Airtable, while deactivated users can't log in.

Admins can deactivate active users managed by their enterprise account and reactivate de-provisioned users.

“Last activity time” overview

The "Last activity time" data is updated once users take a qualifying workspace action in a base or interface owned by the enterprise.

Examples of qualifying actions:

Workspaces

  • Upgrading/downgrading/deleting workspaces

  • Adding/removing collaborators

  • Renaming workspaces

Bases

  • Opening bases

  • Adding and removing collaborators

  • Creating, deleting, and modifying share links

  • Exporting CSV data

  • Uploading and downloading attachments

  • Modifying automations

  • Commenting

  • Viewing share links while logged in

Interfaces

  • Loading interfaces

  • Viewing records through interfaces

  • Updating records through interfaces

Examples of non-qualifying actions:

  • Loading the home screen

  • Logging in / logging out

  • Updating user preferences (eg. Notification preferences)

  • Submitting a form

  • Trying to load a base to which they do not have access

Inviting users through the admin panel

Inviting users

NOTE

  • Admins on Enterprise plans can simultaneously send up to 1000 workspace, base, or interface collaboration requests. The limit for admins on Business plans is 50.

  • Users already collaborating on other workspaces or bases in your organization's Enterprise ecosystem will auto-accept invitations to new bases or workspaces. Users already managed by your organization will auto-accept invitations to groups

  1. Visit your admin panel.

  2. Click Users.

  3. Click Invite users in the top-right corner.

  4. Enter the email address of the user you want to invite.

  5. Search for or select the workspace, base, or interface, or group you want them join.

  6. Click the icon next to the workspace, base, or interface you selected and choose a permission.

    1. You can optionally choose to include a personalized message.

  7. Click Send invitations.

NOTE

If domain restrictions are enabled for your organization's Enterprise plan, you will see a warning for any email addresses outside those restrictions. Additionally, internal domains will appear slightly greyed, while external domains will show white with a light grey border.

Reviewing pending user invitations in the admin panel

Reviewing pending user invitations

NOTE

The pending invites tab does not show pending invites for users who are already collaborating in your organization's enterprise ecosystem.

  1. Visit your admin panel.

  2. Click Users.

  3. Click Pending invites.

NOTE

Admins can use this to tab to search for invited users by email, review when invited and resend or cancel all pending invitations.

Searching, filtering, and sorting in the admin panel

Searching in the admin panel

You can search for users by name, email, or user ID, allowing admins to pinpoint a specific user or query multiple users more broadly. For example, an admin could search for all users with a particular domain name attached to their email address. The number of search results will appear in the search bar as you type.

  1. Visit your admin panel.

  2. Click Users.

  3. Click the “Find by email” search box.

Filtering in the admin panel

There are 4 options to the right of the search bar allowing you to filter your list of users.

  1. Visit your admin panel.

  2. Click Users.

The “Account type” filter has 5 options to choose from:

  • All - This default filter option shows all users who have ever been associated with your organization’s Airtable Enterprise plan.

  • Member - These are active Airtable users whose accounts have not been deactivated.

  • External - This group of users have an email domain that does not match the domain(s) of your company that we have on record.

  • Admin - This option will only show those users with admin privileges.

  • Deactivated - This filter will list out users who have been deactivated.

NOTE

The “Last active” option allows admins to filter users by different periods—anytime, more than 3 months, 6 months, etc.

The third filter option lets admins see a list of users based upon the date that a user joined your company’s Airtable Enterprise account—anytime, which will show all users who have been associated with your Enterprise account. The other 4 options are time-based and will show users who joined 1 month ago, 6 months ago, etc.

Sorting in the admin panel

Admins can sort users by clicking on any of the column names in the header.

  1. Visit your admin panel.

  2. Click Users.

Sorting options:

  • Name (user) - Alphabetically (↑) or reverse alphabetically (↓).

  • Last active - Most recent (↑) or oldest active session (↓). 1

  • Joined on - Most recently joined (↑) or oldest joined date (↓). 2

  • Seat type - Show Editors first (↑) or show deactivated users first (↓). 3

NOTE

Users with blank information in this column were either last active before Airtable started keeping track of this information (November 2019) or have never had an active session in Airtable.
Users with blank information in this column joined before Airtable started keeping track of this information (November 2019) or are external users.
Enterprise customers not yet on our new pricing plan will see this as a “Billable” column. Show billable users first (↑) or show non-billable users first (↓).

Individual user details and actions in the admin panel

Individual user details

To learn more about the individual user details page, please check out our admin panel user details article.

Individual user actions

Admins have access to a suite of tools allowing them to managing user access, permissions, and more.

These options allow admins to:

  • Edit user email addresses.

  • Sign out users from all sessions.

  • Grant or revoke admin access privileges.

  • Deactivate (remove) or provision (reactivate) user affiliations with your organization’s enterprise license.

  1. Visit your admin panel.

  2. Click Users.

  3. Click on your preferred user’s name.

  4. Click the icon at the end of row.

  5. Select the necessary action.

  6. Click Save (when applicable).

Admin restrictions for updating email addresses

  • Admins can’t modify external user emails since they are not considered part of the enterprise account.

  • Admins can’t update their own emails, however, this action can be performed by a different admin.

  • Updated emails must be part of a domain owned by the enterprise account.

  • The email can’t be in use already.

  • The email can’t be changed when the user has two-factor authentication enabled

Bulk user actions in the admin panel

Bulk user actions

NOTE

Admins are not able to perform actions on their own account in order to prevent being locked out.

Admins can also select up to 1000 users and perform actions for the selected group.

  1. Visit your admin panel.

  2. Click Users.

  3. Click the checkbox next your preferred users’ name(s).

admin_panel_users_bulk_actions

Options will appear in the right corner of the header, allowing admins to:

  • Sign out users from all sessions.

  • Grant admin access. 

  • Deactivate users.

Downloading user detail CSVs from the admin panel

Downloading user detail CSVs

Admins can download user detail CSVs offering user context and relevant information for decision making.

  1. Visit your admin panel.

  2. Click Users.

  3. Click CSV in the top-right corner.

NOTE

Learn more about importing CSV files in our Importing third-party data into Airtable article.

CSVs in the admin panel include the following information:

  • User ID

  • User first name

  • User last name

  • Account type (If blank, user is internal)

  • Two-factor auth enabled

  • Email verified

  • Invited by ID

  • Invited by email

  • Last active date and time (UTC)

  • Joined on date and time (UTC)

  • Seat type

Granting admin access to users in the admin panel

Upgrading users to an admins

  1. Visit your admin panel.

  2. Click Users.

  3. Click on your preferred user’s name.

  4. Click the icon at the end of row.

  5. Click Grant ADMIN access.

FAQs

Can I programmatically change multiple email addresses?

Yes, this section of our Enterprise Airtable API documentation will help. This can be especially useful if your company is migrating to a different domain.


Was this article helpful?