This is a security question.
If i have people submitting reimbursement requests in a form and then I have a table view which lists all the reimbursements.
I want the employees to see their own submissions, but I don’t want them to see each other’s.
I’m assuming I would type a formula into the Security Filters area under the table in question, but what kind of formula would I use?
Could I just write USEREMAIL()
Or something as simple as: USEREMAIL() = true
I think I need some way to link the person’s name (which they select from a ref) and the username email.
I have a table with this information, but not sure how to spell it out for app sheet.
USEREMAIL()=[Employee’s Name].[Maintenance Crew Emails] But that didn’t verify.
And then in addition to that, I would like myself and our office lady to be able to view everyone’s submissions, not just our own.
So how would I write that in there?
Would that be right?
Do I separate multiple expressions by just a comma?
Thanks so much! Miranda