Hi, I am searching an external csv file with the select one search(‘csvfile’) appearance, but my CSV file contains 8k lines (street names). It’s making the form freeze for 5 or 6 seconds when I get to this question. I tried using minimal autocomplete(‘csvfile’), with no success. Tried minimal search(‘csvfile’), and this solved the freezing problem, the list is poping up instantly, but I no longer can type a search, having to scroll down the 8k lines list to find the street. I tried using a default value for the field, but with no success.
All I want is the list to not pre load all streets and freeze the app, I need it to start showing results only after 3 or 4 typed chars typed.
Hey @Kal_Lam, thanks for replying my question again!
I am using Excel to create my forms, I should note that I am using the KoboCollect Android App to submit my forms.
But how am I supposed to connect the autocomplete with the external csv file?
When I use autocomplete(‘csvfile’) I get no results
select_one_external nor select_one_from_file works…
Hi @Kal_Lam, thank you very much for your help.
Unfortunately using the search search(‘csv’) didn’t make any diference in the form (I’m using KoBoCollect), The fruits from the CSV file were showing as soon as you open the question. And when you have a 8k fruits csv, it freezes the KoboCollect App.
But I got the solution from the ODK Forum, user @mathieubossaert gave me instructions on some search() options that are not documented. Such as:
Great that you finally found out the solution. Could you be kind enough to share your xlsform with the csv file so that other community members could benefit from the issue that you lodged. THANK YOU in Advance!