Choices are unavailable for a question in a survey created in ArcGIS Survey123 Connect 3.12 if the choice filter column contains keywords

Description

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.

Cause

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'.