How to Restrict Who Can Edit a Field in Airtable

Need everyone to work on an Airtable record, but only a manager should change one field? Use field editing permissions.

For example, team members can fill in a cash request, while only the person approving it can change Approval Status. Everyone can still see the status and update the other fields.

Airtable table showing a locked Approval Status field editable only by managers

Why a field shows a padlock

If an editor cannot change a field, check these things first:

  • The field's editing permission does not include that person.
  • The person has Commenter or Read-only access to the base.
  • The Interface shows the field as view-only.
  • The field is calculated, such as a formula, lookup, rollup, count, or linked record count field.

Field editing permissions are available on Team, Business, and Enterprise Scale plans. Owners and Creators can set them.

Set who can edit the field

Open the base that contains the field. In the table, click the arrow next to the field name and select Edit field permissions.

Under Who can edit values in this field?, choose the permission that fits the workflow. To let only selected people change the value, choose the option for specific collaborators and add those users.

For the cash request example, select Approval Status, allow only the approver to edit it, and save the setting. Team members can still edit the amount, description, and date, but Airtable keeps Approval Status read-only for them.

The selected people still need access to edit records in the base. Field permissions decide who can edit this field; they do not give someone access to the base.

Use the same restriction in an Interface

If people edit records through an Interface, open the Interface in edit mode, select Approval Status, and set it to Editable. The base field permission still applies, so someone who is not allowed to edit Approval Status cannot change it there either.

If the Interface field is set to view-only, nobody can edit it through that Interface. For the full setup, see how to use base-level field permissions to control editing in Airtable Interfaces.

Someone who cannot change Approval Status can still see its value. If a person should not see the field, give them access to an Interface that does not include it and do not also give them base access.

When different teams should edit different records

Field permissions apply across the table. If each team should work only on its assigned records, set that up in an Interface with a current-user or user-group filter. Then use field permissions for the fields they can edit. See how to restrict Airtable access by table, field, or row for that setup.

For current details, see Airtable's field and table editing permissions documentation.