Is it possible to add users to the base and restricting them on a more granular level - prevent the user from deleting fields (columns) in the table. All other editing functions should be unlocked, that is creating views and deleting views even deleting records.
I know at least in theory I could achieve something like this idea by using synced tables (?Right?), but I believe the synced tables add too many restrictions. I am wondering if there is any other way around the security setup for the user.
To be honest I haven’t look too much around, just looked at the collaborators dialogue settings hoping I could see something like that there but it’s not there. Collaborating is something I haven’t used yet, so maybe I am missing something here?
Basically I this is to create the limited user for myself. I am always concerned deleting fields by mistake. The menu option Hide and Delete are so notoriously close to each other. It happened to me a couple of times already when I clicked Delete instead of Hide the field and only found about it later.
I wish there was a same warning for deleting field as it is for deleting whole tables. But I understand some users may find this annoying if adding and deleting fields often. Although I believe Airtable is a database and should not be used in such a way that I would need to delete fields often. The database should be setup well and then using views to be able to filter out what is needed.
This is the warning that would be needed for deleting fields.