I have created an app that represents data from an internal system
I updated data in the app using AppSheet API and I don’t want users to able to edit/add/delete data.
My issue is that if I remove the edit access from a table/column, I can’t update the data from API calls neither.
Is there a way to allow write access through API calls, but prevent modifications from the AppSheet interface?
Thank you,
Tamas
Solved! Go to Solution.
Sure thing. You can attempt to use the CONTEXT(Host)=“Server” expression in the TABLE “Are updates allowed?” dynamic expression area… Maybe something like this…
SWITCH(CONTEXT(Host),
“Server”, “ALL_CHANGES”,
“READ_ONLY”)
I say attempt because I’ve never actually done this.
Sure thing. You can attempt to use the CONTEXT(Host)=“Server” expression in the TABLE “Are updates allowed?” dynamic expression area… Maybe something like this…
SWITCH(CONTEXT(Host),
“Server”, “ALL_CHANGES”,
“READ_ONLY”)
I say attempt because I’ve never actually done this.
I’ve just done this and can say that this is working
Thanks @Grant_Stead, it works fine.
Do you know maybe how can I combine this with useremail()?
So some users able to edit.
You should be able to layer in some OR() / AND() expressions as needed.
Do you leverage a user table for permissions, or are there just a few exceptions that you want to hardcode?
User | Count |
---|---|
43 | |
27 | |
23 | |
14 | |
12 |