topic Re: Problem with select_one list after upgrading field app in ArcGIS Survey123 Questions

Problem with select_one list after upgrading field app

GrantBenn1 — Thu, 11 Mar 2021 12:03:29 GMT

I have just updated my field app (Apple) to the latest version (3.12.274). I was using the app and all was fine, I then updated and immediately one of my select_one drop down lists no longer works. It is the third in a set of three select_one lists which are linked. The survey question no longer presents the drop down list and nothing can be entered into the box.

I have tested the same version on my desktop and found the same behaviour. The drop-down lists work as expected in Survey123 Connect.

Regards,

Grant

Re: Problem with select_one list after upgrading field app

ZacharySutherby — Fri, 12 Mar 2021 16:41:06 GMT

Hello @GrantBenn1,

Would I be able to obtain a copy of the XLSForm for testing on my end to take a deeper look into the behavior?

Once behavior we have noted with the 3.12 release is if a column header used in a cascading select uses a SQLite reserved keyword the cascading select won't work. Please check your cascading selects in the XLSForm to confirm that none of the column headers use any of the reserved keywords.

Thank you,

Zach

Re: Problem with select_one list after upgrading field app

GrantBenn1 — Mon, 15 Mar 2021 09:44:16 GMT

Hi Zachary,

Thanks a lot for the reply. From what I can see the issue is not due to the use of a SQLite reserved keyword. I have attached the spreadsheet.

Regards,

Grant

Re: Problem with select_one list after upgrading field app

ZacharySutherby — Mon, 15 Mar 2021 16:43:06 GMT

Hello @GrantBenn1,

Thank you for passing along the XLSForm! I've taken a look at it and on the Choices worksheet column D has a column header of "group" which is a SQLite reserved keyword. Once I changed it to pv_group and updated the choice filter for the DistrictMunicipality, MetroMunicipality, and LocalMunicipality questions the choice filters worked as expected.

Thank you,

Zach

Re: Problem with select_one list after upgrading field app

GrantBenn1 — Tue, 16 Mar 2021 06:37:18 GMT

Thanks Zachary. I didn't look at that area for keywords. I have made the changes as you suggested and everything is working again as expected.

Thanks a heap for the help.