Ok so I am trying to put together an expression that says these employees on this crew can view a view on the app. I want people both on the admin crew and the maintenance crew to be able to view it.
I have a spreadsheet called Employees. The key is the employee name, but then the other columns are [Useremail], [Crew], etc.
I have other functions on the app that utilize the Employee Name as a ref so I need to keep that as the key. Can’t change the key to Useremail.
So what expression do I use? FILTER? SELECT? Nothing seems to be working. Is it a row ref? Idk. I’m thinking something like this, but I know it’s not quite there…
OR((Useremail() = [Useremail].([Crew]= “Maintenance”), (Useremail() = [Useremail].([Crew]= “Admin”)
What are your thoughts? Remember, Useremail is not the key in the spreadsheet. I feel like I should use a de-ref somewhere but maybe that’s not quite right.