Set Up, Employ enter timesheet Form, 4 user inputs, Date, Duration, Company, Billing Code. I want the user to only see the Company they work for and the corresponding Billing Codes.
When I built the app, I did a Table Customers and a separate Table for Billing Codes. To accomplished this, I put build a Lookup table,
CustomerID, Customer01, user01email,
CustomerID, Customer01, user02email,
CustomerID, Customer02, user01email,
CustomerID, Customer03, user03email,
And put in a security Filter:
IN([Customers], SELECT(Customers to user[Customer ID], [UserEmail] = USEREMAIL()))
But now It want me to upgrade:( from starter to core (Which I will if I have to)
But my issue is this: No expression if can think of or find allows me to filter out a REF column, everything I try says Unexpected type, Ref type cannot except List type... or something like that.
Thus Why I went to security filter!
So Yes users only see their customers and their billing codes, BUT I really want to make it when they select a customer, they can only see the billing codes related to that customer, not all the billing codes they have access to!
Help Please, and thanks in advance!!!
LinkedIn
Twitter
