English

How To: Constrain Select Multiple response combinations in Survey123 Connect for ArcGIS

Summary

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.
Survey XLSForm.

Procedure

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.
  1. In Survey123 Connect for ArcGIS, open the survey XLSForm.
  2. In the survey worksheet, type column, select the cell with the Select Multiple question (select_multiple <list name>).
Select Multiple question in a survey XLSForm.
  1. 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.
    1. In the constraint column, select the cell that is parallel to the Select Multiple question. In the example below, select E3.
Select E3.
  1. In the selected cell, type the following script:
not(selected(., 'option_c') and selected(., 'not_option_c'))
Insert the values from the choices worksheet and name column into the formula above.
Values in the name column in the choices worksheet.
  1. Create a return constraint message when users select both Option C and Not Option C as a response.
    1. In the constraint_message column, select the cell that is parallel to the Select Multiple question. In the example below, select F3.
Constraint message in the survey worksheet.
  1. In the selected cell, type the constraint message:
You cannot select both Option C and Not Option C. 
  1. Save the survey XLSForm.
If the user selects both Option C and Not Option C, the constraint message is displayed.
Constraint message shown when selecting Choice C and Not Choice C.

Related Information