Plan availability | Team, Business and Enterprise Scale |
Permissions | Owners/Creators - Can manage who can update the content of specific fields in your table. |
Platform(s) | Web/Browser, Mac app, Windows app, and mobile apps |
What are field and table permissions?
Field and table permission allow Owners and Creators to limit who can make certain changes to fields or tables.
Updating field editing permissions
To update field editing permissions:
Open your Airtable home screen.
Select the base with field permissions you want to update.
Click the arrow icon to the right of the field with permissions you want to update.
Click Edit field permissions.
Click the arrow icon to the right of “Who can edit values in this field?”
Select your new field permissions level.
Updating table editing permissions
To update table editing permissions:
Open your Airtable home screen.
Select the base with table permissions you want to update.
Click the arrow icon to the right of the table with permissions you want to update.
Click Edit table permissions.
From here you can manage:
Who can create records?
Who can delete records?
FAQs
Why can't I edit a specific field?
If you can't edit a field in Airtable, it's typically due to one of these reasons:
Field type restrictions - Formula, lookup, rollup, count, and linked record count fields are automatically calculated and can't be edited directly. To change these values, you'll need to edit the underlying data or formula configuration.
Field editing permissions - The base Owner or Creator may have restricted who can edit values in this field. Click the arrow icon to the right of the field name to check if "Edit field permissions" appears (only visible to Owners/Creators).
Base permission level - Commenters can't edit field values. Check your base permission level by clicking Share in the upper-right corner, then clicking the dropdown under "People with access."
Interface vs. base context - If you're viewing an interface, the interface designer may have configured it to be read-only or limited certain editing capabilities. Click the arrow icon next to the interface name and select View data to access the underlying base.
View filters or settings - Some view configurations may prevent editing. Try switching to a different view or the grid view to see if editing becomes available.
Who can change or remove the restrictions that I’ve set?
Anyone with Creator or Owner base permissions can configure or remove field or table editing permissions.
Why am I not seeing “Edit field permissions” or “Edit table permissions?”
Only collaborators with Creator or Owner base permissions are shown the “Edit field permissions” and “Edit table permissions?”options.
How can I review which fields have had their edit permissions changed?
Paid plans can use the field manager tool to find information about all of the fields in a given table. Free plan workspace users will need to look at each field's individual editing permissions to figure this out.
How can I adjust who can see information in my base? Can I hide tables from specific users within my base?
Field/table editing permissions do not affect who can see information in the base. To share only a limited subset of information in your base, use a view share link and optionally, a form or consider adding them as interface-only collaborators.
Can lock a field’s configuration?
No. Field locking doesn't include locking a field's configuration (name, type, single select options).
Where do field and table editing permissions apply?
Anywhere that edits can be made - field and table editing permissions apply to our mobile apps, extensions in a base, and to edits made using the Airtable API.
Can I limit editing to just an API script or integration?
Yes, if you limit editing to the specific user whose personal access token is used by the API script or integration or, for OAuth integrations, the user who authorized the OAuth integration.
I see a padlock icon where the plus sign to create records is normally located in a table, what is occurring?
If you otherwise have permissions to create records in a base, but are seeing the padlock icon,the base Creator or Owner enabled table editing permissions that limit your editing permissions.