I have multiple user categories and i want to restrict/allow users based on their category’s access level but appsheet only allows me to maintain 2 access level i.e. User and admin.
Some concepts are described in the article below. Please take a look
2 Likes
Is there any other way where i can define a custom group for the users in a google sheet and use that data for role based access.
That is what the article mentions. In the article there is an Employee table that has Department column. As mentioned therein, you can use LOOKUP() expressions to filter based on the “Department” of the user. Instead of the department, you can use custom group or role as you wish.
3 Likes
Check out this post my friend @Ansu_Halan
[Current_User (Slice) - How to conform your app around WHO is using the app](https://community.appsheet.com/t/current-user-slice-how-to-conform-your-app-around-who-is-using-the-app/35639) Tips & Tricks ?
One of the core basic functions, included in just about EVERY app I make, is the ability for the app to know WHO is using the app. If the app knows who’s using it, then I can easily control many different aspects of the app: Add/edit/delete permissions How data should be filtered What views are shown What buttons, or Actions, are visible Which workflows should fire off Which columns should be shown or editable etc. Requirements To accomplish this functionality in your app, you need the follo…
3 Likes