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
This article contains sample security filter expressions help.appsheet.com - Security Filters: The Essentials
Security Filters: The Essentials help.appsheet.com
OR(USEREMAIL()=โmiranda@ourcompany.comโ,USEREMAIL()=[Employeeโs Name].[Maintenance Crew Emails])
Ok, I used this equation and it seemed to go through but Iโm not sure how I check to make sure it will work:
USEREMAIL()=[Employeeโs Name] = โEmployeesโ[Maintenance Crew Names].[Maintenance Crew Emails]
I change the access mode to โas app userโ but it still showed me other employeeโs submissions.
Then again, it might show me because Iโm the creator?
Not sure if the formula didnโt work, or if Iโm just having trouble viewing it from the userโs perspective.
User | Count |
---|---|
44 | |
34 | |
27 | |
23 | |
15 |