Is it possible to autocomplete from a large list

[nawaf]

1. What is the problem? Be very detailed.
I wonder if there is a way to include a long list of items or ID code and we do auto complete(Like to write the first to # or letter then autocompleteing.
2. What app or server are you using and on what device and operating system? Include version numbers. ODK Aggregate

3. What you have you tried to fix the problem?

4. What steps can we take to reproduce the problem?

5. Anything else we should know or have? If you have a test form or screenshots or logs, attach below.

[mathieubossaert]

Hi @Nawaf and welcome on the ODK forum.
When you get a chance, please introduce yourself on this forum thread and use a real picture as your avatar to help the community building!

Yes you can do it by using external csv files and use the search() function and its start-with option. This recent thread will help you :

Search() function with external CSV file

1. What is the problem? Be very detailed. I am trying to use the search function with an external CSV file. SELECT_ONE ....... SEARCH('STREETS.CSV') It's working, but I have 8k lines in this CSV file, so, when I open the form question on the Collect App, it freezes for 5 or 6 seconds before showing the list with the streets. When I start typing it filters the street names perfect. My problem is with the freezing. Is there a way to not pre load all street names and only start showing results …

In the relevant column you can check the length of the search values to start after 2 or 3 or more characters.

Mathieu

[samanstat]

Thank you Mathieu, I think Nawaf's request is where to put this "SEARCH" under which column? within the ODK design.
Is it under appearance?
Best

[Grzesiek2010]

@samanstat

Is it under appearance ?

Yes, here is the documentation http://xlsform.org/en/#dynamic-selects-from-pre-loaded-data