I continued to try various things and think that I might have found a (semi-comfortable) solution – almost.
I started out with the example questionnaire from Creating a form with cascading select, from a list in an external csv file - User Support / Form Building - KoBoToolbox Community Forum
First of all, this questionnaire created an error message on KoboCollect right for the first question: “File: …forms/EXAMPLE Selects with Choice Filter Search with from file_2-media/cbes.csv is missing.”
After deleting all entries (“search…”) form the appearance column, the example worked. Then I could enter an additional question, simulating a cascade select (as I need it).
Conclusion: select_one_from_file allows cascade select, too, just not as comfortably.
Before, my external csv contained several blocks of a number of columns, the first in each block always representing the name and the second the label, but not being called “name” and “label”, but for instance “district_name” and “district_label”. This allows to add data (e.g. schools) over time easily.
Now, all data with name and label function need to go in the same columns, called “name” and label" – and all additional columns for filtering and pulling data need to be more or less far from there to the right. Slightly more easy to make faulty edits, but it seemed to be working!
Seemed… While it was possible to see and change the choices in Enketo now, the system didn’t let me save it: “Submission Failure. Authentication required. Please authenticate here in a different browser tab and try again.” After following the procedure, it still complained. Interestingly, DATA/Reports (instead of DATA/Tables) showed error 500. Temporary problem or have I still not found a solution to my problem to use cascade select with an external file AND be able to edit data (with Enketo)?
