Hi everyone, I have registration form for users to select the user_competencies (Enum List type Ref to the table competencies) and based on the user_competencies selected they can select the user_skills (EnumList Type Ref to the table skills)
I am having trouble showing the user the skills available for them after they selected the competencies they have, I have tried using deference in the Valid If section writing the following formula.
[user_competencies][Related Skills]
But this will just show multiple key value lists like this
I have also tried adding a virtual column named user_skills_list with the code above and then addig the virtual column as a validation list to the column user_skills, seems to work but only will let me select the skills related to the first competency selected
I want to achieve a functionality where the user is able to select multiple competencies and then select multiple skills filtered from the multiple competencies selected. I have done this already some time ago in one app but I totally forgot how to and where I got the answer.
Solved! Go to Solution.
Try something like SELECT(Skills[Key],IN([competency_id],[_THISROW].[user_competencies]))
Try something like SELECT(Skills[Key],IN([competency_id],[_THISROW].[user_competencies]))
Worked like a charm, thanks Aleksi.
Excellent!
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |