I have four CSV file( district, sub-district, community, governorate) linked together using ID
in the sub-district file, there is a district_id column.
My question is how can I link it together in ODK form using cascading select_one external file.
I will do that once the form ready to use, as I have another issue that you may help solve it.
How can I add (Other) value if it's not listed in the drop down list. I tried use or_other in type column with select_one but after use the form I faced an issue: ( no such column: c_other in the externaldata (code 1)).
But the search function does not return (Other) option, as it compare the id of sub_districts with the sub_district_id inside communities csv file, so it will not find Other option as there is no id for it inside sub_districts csv file