Can we have more than admin and user as a user role in AppSheet. Since I would like to have something like: Admins,Managers,Accounts,Users
Yes and no. You can create a spreadsheet list of the user emails as column A, and their role as column B. Then, you can use expressions likeโฆ
Lookup(USEREMAIL(),โTableโ,โColumn Aโ,โColumn Bโ) This will return the userโs role
Thanks a lot
User | Count |
---|---|
15 | |
9 | |
9 | |
7 | |
3 |