This is a security question. If i have peopl...

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.

Maybe:

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?

USEREMAIL()=miranda@ourcompany.com

Would that be right?

Do I separate multiple expressions by just a comma?

Thanks so much! Miranda

0 3 306
3 REPLIES 3
Top Labels in this Space