Hello great big world. I’m running into a problem. I created a user table to assign access. This particular table has e-mail, district, and location. For district and location I use an enumlist so I can assign more then one thing to that user. I’d like to use that to establish my security filter, but I’m having a problem figuring out the right syntax to make that occur.
I know that if I had built this allowing the user to select it in user settings, this would be easy. It would look like
in([location],usersettings(location))
but alas I need to assign users rights instead of them just selecting it.
So I built it to look like this
in([location],list(lookup(useremail(),“usertable”,“e-mail”,“location”)))
I get no true values when I do that, so I’m not sure what I did wrong here. I’m guessing it’s the list/lookup function, but I don’t know what else I should use.
Please let me know your thoughts
LinkedIn
Twitter
