Hi,
I have added a text box and only want Admin to see this box. I have tried many ways to do this, this is one IF((USERROLE() = “Admin”), “ALL_CHANGES”, “READ_ONLY”).
i have also set a way so that users cant see it, but nothing seams to work.
i also have the option to look up in a sheet for email and yes/no if they are admins.
i only have USER and ADMIN
Can anyone help?
It sounds by a text box you mean a text column or a field.
If so, you may want to evaluate the show_if constraint that works at field or column level
Conditionally show or hide a column value (Show_If) - AppSheet Help
These are table level edit permissions and not field level.
Limit users to particular tables, views, and actions - AppSheet Help
I try to make it so that the users that are on app sheet as admin they are the only people to make changes, but everytime i use the IF and show_IF, it affects all users. i cant seam to devise between admin and normal users.
I have the users added in a tab on Docs and the YES/NO colum for admin with there email and names
In general, your approach seems correct- having a table for the users ( Docs as you call it). If there are just two user roles, instead of Users table to define their role, you could also evaluate to use USERROLE() option to show/hide certain columns based on their roles.
As mentioned earlier, if you wish to limit editing at entire row or table level, you could use
Limit users to particular tables, views, and actions - AppSheet Help