How To: Constrain Select Multiple response combinations in Survey123 Connect for ArcGIS
It is sometimes necessary to restrict users from selecting certain response combinations for surveys that include Select Multiple questions in Survey123 Connect for ArcGIS. This is to avoid inaccurate survey responses.For example, in the survey form below, a Select Multiple question has four possible choices: Option A, Option B, Option C, and Not Option C. If choosing both Option C and Not Option C is not a logical response, it is possible to constrain these choices.
To constrain choices in response to a Select Multiple question in Survey123 Connect for ArcGIS, follow the steps described below:
Note: In this example, both Option C and Not Option C are a restricted combination response in the survey.
- In Survey123 Connect for ArcGIS, open the survey XLSForm.
- In the survey worksheet, type column, select the cell with the Select Multiple question (select_multiple <list name>).
- Create a constraint for Option C and Not Option C. For more information on using the constraint formula, refer to Survey123 for ArcGIS: Formula operators.
- In the constraint column, select the cell that is parallel to the Select Multiple question. In the example below, select E3.
- In the selected cell, type the following script:
not(selected(., 'option_c') and selected(., 'not_option_c'))
- Create a return constraint message when users select both Option C and Not Option C as a response.
- In the constraint_message column, select the cell that is parallel to the Select Multiple question. In the example below, select F3.
- In the selected cell, type the constraint message:
You cannot select both Option C and Not Option C.
- Save the survey XLSForm.
- Survey123 for ArcGIS: Constraints
- Survey123 for ArcGIS: Formula operators
- GeoNet: Survey123 Tricks of the Trade: XLSForm functions for lists