How to make a table/column to be writable only through API?

[rhen]

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

[Grant_Stead · Accepted 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.

[Fabian_Weller]

I’ve just done this and can say that this is working

[rhen]

Thanks @Grant_Stead, it works fine.

Do you know maybe how can I combine this with useremail()?
So some users able to edit.

[Grant_Stead]

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?