Skip to main content
Solved

Preventing accidental record deletion


Hi! Five users are working with thousands of records in a table, and sometimes records accidentally get deleted. Is there any way to prevent record deletion per user, but still allow editing on the records? (except the primary field name)?

Best answer by Pete11

Hi Dina,

At the moment, Airtable doesn’t have a user-permission level that permits record-editing but forbids record-deletion. As you’re likely aware, edit-collaborators can change/clear the values in any records on a table. They can also delete records entirely. We’re working on product improvements to better accommodate the need for more granular permissions.

For what it’s worth, I’d note that you can check a base’s trash to see (and restore) any records that have been deleted within the past seven days.

With regard to preventing collaborators from editing a table’s primary field, if you’re on a Pro workspace, you can sign up for our field and table editing permissions beta.

Hope this is a bit helpful!

View original
Did this topic help you find an answer to your question?

3 replies

Forum|alt.badge.img+17

I don’t think so, but you have Undo and Screenshots features to save that data.


Forum|alt.badge.img+11
  • Participating Frequently
  • 28 replies
  • March 2, 2020
Elias_Gomez_Sai wrote:

I don’t think so, but you have Undo and Screenshots features to save that data.


Hi @Elias_Gomez_Sainz

I believe you meant Snapshot ?

This request is a recurring one I get from clients.
Undo and Snapshot are for sure helpful. But it happens that users delete records without even noticing.

Is anyone aware of a workaround here? Or at least knows a way to create an alert when a record is deleted? That could be an interesting trigger to add to Zapier: “When a record is deleted”


Forum|alt.badge.img+12
  • Inspiring
  • 45 replies
  • Answer
  • March 4, 2020

Hi Dina,

At the moment, Airtable doesn’t have a user-permission level that permits record-editing but forbids record-deletion. As you’re likely aware, edit-collaborators can change/clear the values in any records on a table. They can also delete records entirely. We’re working on product improvements to better accommodate the need for more granular permissions.

For what it’s worth, I’d note that you can check a base’s trash to see (and restore) any records that have been deleted within the past seven days.

With regard to preventing collaborators from editing a table’s primary field, if you’re on a Pro workspace, you can sign up for our field and table editing permissions beta.

Hope this is a bit helpful!


Reply