Hi all,
Iโm a new AppSheet user and am having difficulty getting columns filtered by USERROLE.
Notes:
In the App preview window, with โPreview asโ assigned to one and then the other user, all columns are shown regardless of user type. From what I read, this may be an issue with the preview window.
However, the same holds true for the app when on my phone, or when logging in to the browser version of the app. All columns show.
What am I missing?
Many thanks,
David
Hello
For the case that I had to solve, I did the following:
Groups of students in a school
Each teacher has their email
Each teacher is assigned to all students in certain groups
In a column of the students table, I put a field with the name Teachers_Asignados, in that field, for each student, I put the emails of the teachers that can see that student and I compare it with the username they use to access the App.
For that I use a formula in the security section of the Table, the formula verifies two things, first that the teacherโs email is in the field that I commented before, and it also verifies a special list that I have for administrators
The Formula is:
Or(CONTAINS([Teachers_Asignados], USEREMAIL()),USEREMAIL()=
ANY(LIST(value1, value2)))
Where value1, value2, I can change it to the administratorโs email that is needed at the time.
I hope you find it useful
User | Count |
---|---|
43 | |
28 | |
23 | |
14 | |
14 |