Hey @Alexandre_Husset ,
as far as I know, you can not access the doc admin status inside the doc. You can get the “Doc user”.state but as I understand it only shows what you have set in the doc sharing options, not if the User is a Maker.
The way I achieve what you want is by seperating the official Codas doc permissions from my own set up permissions in the doc.
You can do that by creating a table “users” where you list all your users and have a column with the Coda User to connect them. Add another column and set up the “doc permissions” for each user. I use the “Team” column for that in the example, and it’s even multi-select.
In the team column, a user can be an admin, finance, design, website, …
You can now filter any table based on the current Coda users specific row and his permissions.
E.g. I made myself a formula that reads the permissions of the current user (called CurrentRights & returns a list) and on the respective tables I filter by checking if the needed permissions are included :
Now the content of this table can be seen by the Website team and Admins.
But you really have to make sure that all important parts and the canvas is locked and no one can play around with filters or permissions.
I have tested to hack this by myself and was not able to, as long as locking is set up properly. I also tried to get the data via network tab, local storage, … but did not found the filtered results. So for my not-so-sensitive-data, this is totally fine. There might still be ways to hack around this, depending on how the filtering works under the hood. If someone knows how secure this is, it’s probably @Paul_Danyliuk .