- 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!