Dynamic selects from pre-loaded data error

sf_id.csv (616.6 KB)
ke_esigning_app.xlsx (97.8 KB)

Hi - I'm getting this error (shown in whatsapp image jpeg attachment) and can't figure out how to fix it. It was working fine for the past few weeks, then it suddenly started showing this error after an update.

Hi @Mark_Huelsenbeck and welcome to the ODK forum! When you have a chance, I'd encourage you to introduce yourself here. Doing so helps build community!

I tested your form on my Collect 1.30.1 (Central 1.2 backend server) and it works smoothly.

Which version of collect are you using?
Which device and Android version are you testing it?

Aurelio

Hi @Mark_Huelsenbeck, I have made some changes to your form and CSV file, kindly try the attached file and let me know if your problem is solved.
sf_id.csv (616.6 KB)
ke_esigning_app.xlsx (97.8 KB)

Thanks

1 Like

thanks so much for the help. this worked.

thanks for testing.

I realized that an agent had accidently opened the .csv file and added some characters in the column header; hence the error.

Do you know if dynamic selects/proloaded data still works if you protect the data in the .csv sheet (so no one can accidently edit it)?