Invalid permissions accessing metadata API

[Patrick-Kennedy]

I don’t see anything in the Developer docs for Apps or Scripts which has the option of setting a table’s or field’s permissions.

There are methods to see if the table or user has permissions to make changes, but none to set them through the API as far as I can tell.

Use case: I have created an archive of a large base with many tables for posterity prior to deleting a bunch of data. I’d feel better with the archive copy locked down to prevent any modifications.

It would be great to be able to for-loop through the table’s and fields to lock them down in order to prevent record deletion, new record creation, and modification. Is there a way to do this programmatically or only through the GUI?

[kuovonne · Accepted solution]

Currently this can only be done through the GUI. Fortunately, you can now make bulk edits to field permissions in the GUI. (Before you had to make changes one field at a time.)

[Patrick-Kennedy]

Oh, interesting… Are bulk field permission mods an Enterprise plan thing, or is this something afforded by a Pro plan?

Thanks @kuovonne!!

[Patrick-Kennedy]

kuovonne:

bulk edits to field permissions

Airtable Support

Using field and table editing permissions

With field and table editing permissions, you can limit who can make certain changes to fields or a table. For example, you can make sure that only some coworkers can mark a project as approved, or...

Nice!!