I’m trying to figure out how to do something a little bit tricky here.
So, I have a user table with a column where a formula return all the accessible Zones delimited by a
Then in my data editor, I do a split by
, and then a relation with the zones names to get them all
Now I have a list of zones (which have multiple entries) and I would like to just display for the current user the zones that are in his Accessible Zone relations list. But is included in doesn’t support array or relations. Any idea?
Why on earth am I doing this?
I’m doing all of this because we can’t combine AND and OR in a view filter. I would like to do
Agency = user.agency AND active = true and [ restrictedTo is empty OR restrictedTo includes user.businessUnit]. So I did a formula using
FILTER and a
JOIN to create a comma-separated list of the zones a user can have access