1. What is the problem? Be very detailed.
I am trying to auto-populate the text fields according to EMIS number selected from the dropdown menu. As the EMIS number is unique for all the schools in my form I am using it to populate school name, bank name,(these are all text fields), etc. I upload a CSV containing all the data and used search('CSV Name') and pulldata() to achieve this.The EMIS dropdown is working fine but autopopulation for rest of fields where I used pulldata() does not work.I am not sure what I'm doing wrong.
Formula I used : pulldata('school_list', 'Region', 'New_EMIS_Code', ${New_EMIS_Code}) 2. What app or server are you using and on what device and operating system? Include version numbers.
I'm using ODK central version 1.2.2. on our AWS Server and latest version of ODK Collect. 3. What you have you tried to fix the problem?
Tried changing name in the choices and also column names. 4. What steps can we take to reproduce the problem? school_form.xlsx (62.6 KB) school_list.csv (634 Bytes)
5. Anything else we should know or have? If you have a test form or screenshots or logs, attach below.
Region not appearing after selecting EMIS :
Hi @Ricardo1,
I moved your pulldata to the appearance column as per the docs, and renamed the EMIS code field to New_EMIS_Code_key (and also in the choices name/label & in the CSV) for fast CSV lookups, as explained here
(I think the docs for Dynamic selects from pre-loaded data could be better, fruits is used as the name of the reference CSV, the widget name and the choice list name. Changing them so they're all unique would make it clearer)
@ahblake@mathieubossaert one more thing the search('csvfile') dropdown is not appearing in odk central though it shows the dropdown in odk collect.Any reasons for that?
@mathieubossaert After creating a public access link too it doesn't work. It only works in ODK Collect.
Is it the same as the preview? So we cannot make submissions in central I suppose.