Here’s what I’m trying to do:
‘Person’ table contains a list of people, and it contains a multiselect column for skills. This multiselect column is looking up the skills from a separate table.
I want to create a view of the Skills table, for which I can use a Select tool, select a person, and the skills table view will show me just the rows for that person’s skills.
So here’s the code I attempted for the filter on this view:
[Person Table].Filter(Name=[Person Select].Name).Skills.Contains(thisRow.[Skill Name])
And this works… but only if the person has just one skill selected. If the person has two or more skills selected, this view is blank. I’ve also written a similar formula using ‘In()’, and got the same result with it. Why isn’t this working and what do I need to change to make this work for my multiselect entries?