Option "other" in dynamic select_one with preloads

  1. What is the problem? Be very detailed.

I have a dynamic choice list with preloaded data (the names of household members). It works just fine but I would like to have an "other" option in the choices, e.g. to account for the possibility that there is a housheold member we did not record before.
When I use the normal "or_other" addition to the select_one in the type field I get an error message when filling ou tthe questionnaire in ODK Colect.
Th eerror message says: "no such column: c_other(Squlite code 1): while compiling SELECT c_other FROM externalData WHERE c_hh_key LIKE ?, (OS error - 2:No such file or directory)."
Note: "hh_key" is the key variable to access the preload data.

3. What you have you tried to fix the problem?
I was thinking about manipulating th epreloaded data and add a fake household member with the name "other" to the list of hh members. But that seems overly complicated.

If you need any more info, I am happy to provide that.
Looking forward to your suggestions!
Best, Rebecca

Hi @Rebecca_Lo
or_other option work only with plain selects if you work with external itemsets you need to add such other option manually so yeah that what you found overly complicated is the solution int this case.

1 Like

Hello @Grzesiek2010,

oh that's disappointing. Thank you anyways for the quick response!