1. What is the issue? Please be detailed.
I'm using ODK Collect v 2024.3.0 Beta 7
I'm using a choice filter that involves multiple values in a single cell separated by commas. Behavior is inconsistent between Enketo and Collect.
Here is my form design:
2. What steps can we take to reproduce this issue?
The grid above shows behavior of Collect and Enketo with 2 variables changed.
Checkmarks = proper behavior
Orange = no responses visible
Pink = Doesn't show items that have a comma at the end of the word. so
Carpentry, Welding wouldn't show responses for Carpentry
First variable is the choice filter in Cell I6 either being
regex(skills, ${skill})
selected(skills, ${skill})
Second variable is the comma separated values in the skills column in the choices sheet.
No spaces = Painting, Carpentry
Spaces = Painting , Carpentry
3. What have you tried to fix the issue?
Added spaces in the choices column between values and changed the choice filter formula between selected() vs regex() but I'm not sure why this makes things work or what is going on in Enketo and Collect.
4. Upload any forms or screenshots you can share publicly below.
TEST_Farm_Time Selected w Spaced Commas.xlsx (10.0 KB)
Regex, no spaces
TEST_Farm_Time.xlsx (9.9 KB)
This form was created from what I saw here. Scroll down until you find: Functions on strings