Solved: How to make a table/column to be writable only thr... - Page 2

rhen · 11-03-2020 06:07 AM

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

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.

View solution in original post

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