Field Permissions: No edit privileges except for Scripts/Blocks

Certain blocks require users add an editable (non-formula) field to a table to hold misc data which shouldn’t be directly edited by the user (i.e. the Map Block requires a geocache field). Many Script Block scripts semi-automate or standardize data entry processes to provide a form of data validation or workflow integrity.

I think it would be nice if Airtable’s field permissions included a toggle for " Allow this field to be set in scripts/blocks/API" when the field permissions are set to: “Who can edit values in this field > Nobody”. For fields with permissions set to “Who can edit values in this field > Nobody”, there is already a toggle for “Allow this field to be set in records created through forms”, this would work similarly. This will help collaborators who should have the ability to edit data as determined by the script/block do so, but not directly to enforce some measure of data consistency in all the cases where a Formula would be insufficient.

5 Likes

Upvote!

BIG +1 from me on this feature.

This would come in very handy when you don’t want base users to mess with the content or structure of your base, but would still allow them to add/edit/delete records through the scripting block, therefore enforcing your desired business rules.

Just Noticed that there is a permission option to allow the record to be edited through automations.
Wondering if Airtable is also going to add this feature to the scripting block??

Also if this means that they create a permission to allow the script to create new records?