I have a Document where I am the owner and I invited someone as a guest as an Editor. I made this document for her, and she uses it on a daily basis inputing data. I only manage the structure and working state of the document.
I blocked her at the Structure level unchecking the box in the Access Rules page, because she accidentely deleted some formulas, and we agreed to it as the best solution. But… she would like to change the layout sometimes, like filtering and sorting, but that is also blocked with that rule.
The question: Is there a way to block formula changes, and main Table properties, but allow filter and sorting saves?
Hi @Paul_G_Janzen, unfortunately no way to block structure access more granularly. It’s come up before, and we are interested in this too. One idea is to break up the single “Allow editors to edit structure” permission into several:
Permission to create and edit formulas
Permission to manage pages and layouts (this would include filtering/sorting)
Permission to manage data tables and columns (including deleting them)
We don’t have an ETA for this in part because there hasn’t been clear enough need. So it’s good to get this request along with the explanation. If anyone else sees this thread, you are welcome to chime in, to let us know your use case and if this would be helpful.
It’s not a big need, but some of my users like to add their own tables and try out things with summaries & charts - but I would very much like to prevent them from editing formulas in the important tables.
As far as I know that’s not possible with the current special rules (My thought was to put table.name.startswith('test'))
It seems there are several requests for this or very similar permissions. I’ve replied to others - I’d love to have something like this, ideally even to the Table level - protect some core tables but let an Editor (or other custom Role) create/manipulate their own views on that data.