Unless Im missing it, I would like the ability to lock changes to fields in a base and/or records. Would help prevent accidental deletion. I discovered several days later I had done this…
+1…
In my case, I’m using Airtable as a database/CMS for an app. For certain tables, If I make a change in airtable it won’t sync with my actual firebase database. So I need to lock fields so Admins, don’t think it will.
Use case : I am the only user of my base. I have multi-select fields which are very sensitive (linked to external APIs) and I want to lock myself from accidentally creating new options while creating/editing records (which happens way too often…).
Expected functionality : In the “Customize field type” section of the column header, I expect to see a switch ON/OFF called “Block creation of new options when editing records”. Not asking for granularity among users : I just want to make sure the available options can only be edited from the “Customize field type” section.
Actually, if that option is / becomes available, I would use it for most of my Single-select fields, since in my opinion such fields are often meant to be used in formulas and should not be messed with. I do consider that option should be a default, and the switch should be labelled “Allow the creation of new option while editing records”. But that is obviously just a personal opinion ! Whichever way, as long as the switch exists :slightly_smiling_face:
Thanks for any feedback (does this option already exist in a way ?) and listening to community requests !
I need a way to keep records from accidently being deleted. It’s frustrating that even with the pro plan I can only see deleted records for the last 7 days. I have had a few records disappear and there is no way to look for them if you don’t realize until after a week, and there is nothing to prevent this from happening. The ability to lock and unlock would add a layer of protection to keep things from being deleted accidently.
Hi, we released field & table editing permissions in April.
With field and table editing permissions, you can limit who can make certain changes to a field or table. For example, you can make sure that only some coworkers can mark a project as approved, or prevent anyone from inadvertently deleting records.