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…
I would love to be able to lock some fields as well ! So that my employees would be able to modify and use my template without changing the multiple select possibilities of my field.
+1
Even when I use the database myself, I occasionally find me entering a value that is not in the list. The field will accept it obviously as a new value. I don’t want that. I would either like to see a message that this value is not in the list, or even better: having the ability to lock the values.
+1 vote from me. We also have a set price guide that should not have any changes made to it. I am new to AirTable and loving it. I understand you can’t lock a record. Can a full table be locked?
+1
Our use case is we have a huge list of Thing A with counts and a bunch of manually-created categories, and a second table of Thing A we use to paste in updated counts (because that’s the only data being updated and we don’t want to disturb all the other fields, especially our hard-won categories). When we paste in the list of current Thing A’s and their counts to the update table, any new unique Thing A’s transfer over to our main table, and the new counts transfer as well. That’s good! But this week someone got confused, and pasted the new Thing A’s directly into the main table, and since they were in a different order, they wiped out the connection between the Thing A’s and their proper categories. So basically we would like for the Thing A field in our main table to be open to the creation of new rows of data, but locked to overwriting of existing rows. Even better would be if this were variable by person or role.
Exactly – infinite use cases for this. I’m tracking submissions, by person and company. After a submission has been made – I need it saved forever. If a person changes companies, or if a company changes through Acquisition or merger – I need to be able to update my tables without it changing the Submissions records.
We collaborate across multiple teams/departments and I would love the ability to lock down Single/Multiple selects so other users are not allowed to add more Options and only use the available selects.
+1 again, accidental deletions are a real problem for our team. I’d like to be able to lock to prevent accidental deletion and make sure additions and edits are purposeful. For a given field, I’d like to set “lock” that requires a simple “unlock” button to edit.