Security filter formula I use :
IF((USERROLE() = "Admin"), "ALL_CHANGES", "READ_ONLY")
AppSheet said I need to return true or false
Solved! Go to Solution.
Welcome to the AppSheet community !
Security filter filters the records that reach different users' devices based on the expression. They do not control record level add/update permissions.
Security filters: The Essentials - AppSheet Help
For controlling if a record can be edited or read by user please use the below option "Are updates allowed" under Date --> Table option
Control add, update, and delete operations - AppSheet Help
So you could use an expression something like below in "Are updates allowed"
SWITCH(USERROLE(),
"Admin", ALL_CHANGES",
"READ_ONLY")
Or it can be as per your expression
IF((USERROLE() = "Admin"), "ALL_CHANGES", "READ_ONLY")
Welcome to the AppSheet community !
Security filter filters the records that reach different users' devices based on the expression. They do not control record level add/update permissions.
Security filters: The Essentials - AppSheet Help
For controlling if a record can be edited or read by user please use the below option "Are updates allowed" under Date --> Table option
Control add, update, and delete operations - AppSheet Help
So you could use an expression something like below in "Are updates allowed"
SWITCH(USERROLE(),
"Admin", ALL_CHANGES",
"READ_ONLY")
Or it can be as per your expression
IF((USERROLE() = "Admin"), "ALL_CHANGES", "READ_ONLY")
User | Count |
---|---|
16 | |
10 | |
9 | |
8 | |
3 |