Plan Availability | All plan types |
Permissions |
|
Platform(s) | Web/Browser, Mac app, and Windows app (with some additional limited support on mobile) |
Adding user fields in Airtable
The user field allows you to select one or more collaborator and non-collaborator names from an automatically generated dropdown list of users. This article covers how to use user fields to streamline your team's and organization's work.
To add user fields to a base:
Open your Airtable home screen.
Open the base where you want to add user fields.
Add or edit a field.
Search for and select User.
From here, you can toggle the "Allow adding multiple users" button ON/OFF to permit or remove adding multiple users per record.
Additionally, you can toggle the "Notify users with base access when they're added" button ON/OFF to ensure anyone added to a record is made aware they're included.
Adding users to user fields in Airtable
Note
Unless users have turned off their email notifications or their email address is unconfirmed, they will receive an email at the email address associated with their Airtable account.
After adding users to a record, they automatically start watching the record and its associated comments—meaning they are notified when someone comments.
To add users to user fields:
Open your Airtable home screen.
Open the base with the user field where you want to add users.
Click the + icon in the record you want to update.
Search for and select your preferred user(s).
Click the ⌄ icon under the “Permissions” section and select your preferred user role.
Click Invite to base.
Removing users from user fields in Airtable
To remove users from user fields:
Open your Airtable home screen.
Open the base with the user field where you want to remove users.
Locate the record with the users you want to remove.
Click the “X” to the right of the user’s name
Converting existing fields to user fields
Note
When converting an existing field into a user field, individual records are matched with a current user or cleared. If the field matches a single user's first name, full name, or email, it is converted to that user. If the content of a cell doesn't match a single user or it's ambiguous (e.g., two collaborators with the same first name), the record is cleared.
To convert existing fields to user fields:
Open your Airtable home screen.
Open the base with the field you want to convert.
Click the ⌄ icon next to the field’s name you want to convert to a user field.
Click Edit field.
Click the existing field type, then search for and select User.
From here, you can toggle the "Allow adding multiple users" button ON/OFF to permit or remove adding multiple users per record.
Additionally, you can toggle the "Notify users with base access when they're added" button ON/OFF to ensure anyone added to a record is made aware they're included.
Click Save, then Confirm change.
FAQs
How do I count the number of users I have in a field?
You can count the number of users in a field by adding a formula field using the formula below:
IF({field_name},LEN({field_name})-LEN(SUBSTITUTE({field_name},",",""))+1) NOTE
Be sure to replace "field name" with the name of your user field.
Does adding a user to a user field allow them access to the base where that field is?
Users who are selectable in a user field already have some kind of permission in the workspace where your base/interface resides. Users will need workspace, base, or interface access to appear in the dropdown. By adding a user token to a user field it will not change their current permission level.
To learn more about permissions as they relate to billing, please consult this article.
Why aren't collaborators who are added to a form's user field notified when the "Notify user when added" setting is enabled?
Collaborators added to user fields are not automatically notified when a record is created through a form submission. Notifications are triggered by direct actions within the base, interface, or through specific automation setups.
Although there isn't a form setting to enable collaborator notifications, you can set up an automation to send notifications when a record is created via a form.