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

security
(Timothy Martin) #1

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")

(Timothy Martin) #2

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.

(Challa Ramakrishna) #3

@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])

(Aleksi Alkio) #4

@Challa_Ramakrishna I believe you mean… IN(USEREMAIL(),[ManagereMail])

(Challa Ramakrishna) #5

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