I am using the below code in a security filte...

I am using the below code in a security filter to show my employees their own records, and allow for the managers to see everything. This works great for the employees but when the managers go to their record is shows every employees record. How can I make it so the managers see only the records of the specific employee row? OR([Email] = useremail() , useremail() = "manager1@email.com" ,

useremail() = "manager2@email.com" , useremail() = "manager3@email.com" , useremail() = "manager1@email.com" , useremail() = "manager4@email.com" , useremail() = "manager1@email.com" , useremail() = "manager5@email.com")

0 4 365
4 REPLIES 4

I have also added a signature to my form and even though it is marked as required, it still allows the form to submit without the signature.

@Timothy_Martin Each employee must be related to a manager. make sure that each employee records saves the email of the manager in another column.

Then itโ€™s easy to filter out the data. IN(USEREMAIL(),Emp[ManagereMail])

@Challa_Ramakrishna I believe you meanโ€ฆ IN(USEREMAIL(),[ManagereMail])

@Aleksi_Alkio yes, or USEREMAIL() = [Manager email]

Top Labels in this Space