Hi I am trying to build a Sales Application. I have following tables :
-> Stores a list of Retail Shops with City_id column 2. Sheet1 -> Table storing a list of Cities with their corresponding
“District_id” 3. Usersloc -> Table containing user and the district_id in which the user functions
Right now in the
List view of “outletdetails”, all the records in “outletdetails” are visible. I want only those records to be visible to the user where city_id is in the allowed district_id of the user. If one user is handling more than 1 districts, another row is added in Usersloc table.
I wrote the following expression for the security filter for “outletdetails”. It should compare the district_id of the outlet, with the district_id allowed for the user.
“city_id”, “district_id”) = LOOKUP(USEREMAIL(),
“Usersloc”, “user_email1”, “district_id”)
In spite of this, it shows all the records.
Can somebody guide where I am going wrong?