Enter and view data for each user

Hello everyone, can you help me solve this problem: how to make the teacher of class 4A only be able to enter and view the scores of students of class 4A, how to make the teacher of class 4B only be able to enter and view grades of 4B students (in the whole school's data sheet). And, principals can enter and view all students' grades.
Thank you very much everyone.

0 2 89
2 REPLIES 2

Use the security filter of the score table assuming that both teacher and students records have a class column.

Put something like

[student reference].[class] = LOOKUP(USER EMAIL(), "teachers table", "teacher email", "class")

Thank you for your support, I will try your solution