Problem: Choices are unavailable for a question in a survey created in ArcGIS Survey123 Connect 3.12 if the choice filter column contains keywords
When creating a survey in ArcGIS Survey123 Connect 3.12, if a question uses the choice filter column with certain keywords in the survey sheet, for example 'group', the question is unable to select choices from the column with the same keyword in the choices sheet.
In this example, both questions of the survey use the choice filter column, with the first containing choices from the 'GROUPING' column, and the second containing choices from the 'GROUP' column in the choices sheet.
When previewing the survey, the choices are available for the question using the 'GROUPING' column, but is unavailable for the question using the 'GROUP' column.
The name used in the choice filter column of the survey sheet and corresponding column in the choice sheet is a reserved SQL keyword. In this instance, the reserved SQL keyword is 'GROUP'. This is a known limitation for ArcGIS Survey123 Connect 3.12 that uses a database approach for managing choice lists.
Solution or Workaround
Avoid using reserved SQL keywords in the choice filter column. Refer to SQLite: SQLite Keywords for more information on reserved keywords. As a workaround, use similar words that are not the SQL keywords, for example, 'grouping' instead of 'group', or 'ordering' instead of 'order'.
- ArcGIS Survey123 Blog: What's new in ArcGIS Survey123 (February 2021)
- ArcGIS Survey123 Blog: Survey123 Tricks of the Trade: Choice Filters
Last Published: 4/7/2021
Article ID: 000025216
Software: ArcGIS Online 8.3