We are building a form which requires a user to select a health facility (one out of 1,500) via an auto-complete search from data stored in a CSV file (no need to have a database table for it) and save the value in a Text Obs value, then have the same list displayed during editing
The text file has only two columns see sample below
| uuid | name |
|---|---|
| ab4uj76 | Health Facility 1 |
| dimnyu7 | My Family Clinic |
| pl098jb | Main Regional Referral Hospital |
A couple of questions
- How would one support this in HTML Form Entry - we already have the text obs concept setup
- How can I load the CSV into memory and use it as an autocomplete
Looking forward to hearing from you all cc @mogoodrich @mksd @mseaton