Hello,
we try to filter a second list by the choices of the first one, using selected(…) expression in then choices sheet.
It seems, as if expression is not working here and just a text interpretation might happen here, like boolean(:'x:). See attached file: Dynamic Choices - with Expression 02.xlsx|attachment (12.4 KB)
Are we doing something wrong? (@Kal_Lam)
Dear Kai,
thank you very much.! Yes, this works, we have tried it before the posting, as cited above.
But we did not understand, why our approach doesn’t work. Would be great, if you try to explain it with the our xls (attached before).
My feeling is that the MyChoiceFilter column in the CHOICES sheet is only treated as text literal by KoBo. That means that you NEVER can use there something like ${var} there, neither any function.
Could you confirm this, please? (We did not find a hint on this restriction in the community discussion or in ODK/XLS/XForm manuals so far.)
Kind regards
Wolfgang
Hello. What will be the choice filter when I select province from the previous question and in the next question it only show villages related to the previously selected province?