Hi,
In the user setting, Iโve set up an enum list with multiple options that users can chose from, letโs say itโs a country list with (US,Canada, UK) there as an option. And thereโs a security filter: [country]=USERSETTINGS(country). But then when people select (US,UK) in the setting, it returns those rows with country that contains both US AND UK at the same time instead of displaying the rows which contains either US OR UK as i intentionally designed. Would there be any solution to this?
Thanks in advance!
Best,
You should type IN([country],USERSETTINGS(country)).
Thanks again Aleksi, youโve been super helpful!
Youโre welcome
User | Count |
---|---|
36 | |
33 | |
27 | |
23 | |
18 |