I would have to revert to an earlier version of the form, unfortunately, I save over previous versions and so I do not have the earlier versions on hand (unless you guys can go into the project and look at the previous versions, I did like 30 uploads while trying to figure out how to get it to work!). However, the issue was that when I set up the form to search() from the CSV, it would simply refuse to read the CSV and would not add the options to the Kobo form, pulldata() and select_one_from_file failed too. I tried every combination and method I could find, and even uploaded these sample forms from the ODK forums and they did not work either:
hhcensus_data.csv (2.2 KB) Sample_Baseline_2017.xlsx (42.7 KB)
Result is always the same: Form would load, but data from CSV would not work and just leave blanks in the fields it was supposed to fill.
After trying everything I could think of, I started to question the CSV itself, and it was not until I reduced the CSV to just the three columns I needed that it worked, and so my current form is using 2 separate csv files that are 3 column subsets of the original one that I uploaded earlier, and then I have each question refer to its own CSV. (which you can see in lines 5 and 7 of the form uploaded in previous comment “sampleform.xlsx”).
I was expecting to be able to upload one CSV with the whole baseline in it, and simply select the coumns I needed in the parameters for search() and pulldata(). Instead had to create separate documents.
Regardless, it would seem that I am maybe doing something wrong with the CSV files, because even though I managed to get the Enketo online form to work by subsetting, the CSV files still refuse to download into the KoBoCollect app. This is not exclusive to me, my whole team was unable to download the form into their KoBoCollect apps. We are all on latest version from Playstore (installed on Friday).
I am sorry I cannot give you screenshots of the webform failing, I will try to reproduce the problem this afternoon.
Thank you for all your support.
