HOW TO

Constrain Select Multiple response combinations in ArcGIS Survey123 Connect

Last Published: May 6, 2022

Summary

It is sometimes necessary to restrict users from selecting certain response combinations for surveys that include Select Multiple questions in ArcGIS Survey123 Connect. 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.

The Survey XLSForm.

Procedure

To constrain choices in response to a Select Multiple question in ArcGIS Survey123 Connect, 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 ArcGIS Survey123 Connect, open the survey XLSForm.
  2. In the survey worksheet, in the type column, select the cell with the Select Multiple question (select_multiple <list name>).
The Select Multiple question in the survey XLSForm.
  1. Create a constraint for Option C and Not Option C. For more information on using the constraint formula, refer to ArcGIS Survey123: 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.
The 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.
The Constraint message in the survey worksheet.
  1. In the selected cell, type the constraint message, as shown below.
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.
The Constraint message shown when selecting Choice C and Not Choice C.

Article ID:000020969

Software:
  • ArcGIS Survey123 Connect

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Related Information

Discover more on this topic