Hello all, I am having trouble with expressions - again.
I am in the security filter field for a table entitle “Design Numbers by Client”.
I have the client names in the first column, and then the plant names in the remaining columns going across.
I would like app sheet only to show the names of the clients that the user is assigned to.
I have this information located in another table called “Employees”.
The table’s columns are “Employee Name”, “Useremail” and “Crew”. I also put the expression USEREMAIL() in the app formula field in the “Useremail” column to try to make sure app sheet understood this link between the “Employee Name” and the “Useremail”.
The assignments of each employee to their client are in yet another table where I have the “Client Name” as the key and first column, and then the “Employee Name” is another Column in the table which is a REF to the aforementioned “Employees” table (the second table) where the Employee Name is the key of the table. I also put =UNIQUEID() in the Initial Value field of the Employee Name column because I read somewhere to do that.
So I am using the following equation in the security filter but it is not working, nothing actually appears in the view for that table when it should show me at least my own assigned clients.
(It shows them all when I have no filter so I know the info is there).
[Client Name].[Employee Name] = USEREMAIL()
I have also tried this but it doesn’t work: [Client Name].[Employee Name] = USERNAME()
What am I missing?
Am I doing this wrong?
I have tried to make sure that I have keys and refs and all that in the right place, but to no avail!