HOW TO

Conditionally hide and embed additional questions into a multiple-choice question in ArcGIS Survey123 Connect

Last Published: April 23, 2024

Summary

In ArcGIS Survey123 Connect, formulas can be applied to survey questions to set conditional formatting to hide or embed questions when a particular choice is made. For example, customizing a survey question to show a textbox and a multiple-choice question prompt when the respondent selects 'Yes' to the question.

This article provides the steps to conditionally hide and embed additional questions into a multiple-choice question in ArcGIS Survey123 Connect.

Procedure

  1. Open the ArcGIS Survey123 Connect XLSForm.
  2. Create a multiple-choice question in the survey worksheet. In this example, the select_one yes_no question type is created.
    1. Under the type column, select text to embed a text question.
    2. Specify a name for the question that is not listed in the Reserved worksheet, and under the label column, type <font color=""></font> to display a blank label for the text question. In this example, the question is named 'elaboration'.
The edited XLSForm
  1. Under the relevant column, specify the following formula:
${<targetQuestionName>}='<targetChoiceSelected>'
Note:
The relevant column hides the questions and clears the questions' record when the answer chosen is not relevant to the expression. In contrast, the body::esri:visible column hides the questions from view but still records the data.
The code block below is an example of the full working formula.
${firstQues}='yes'
The edited XLSForm
  1. Under the type column, select select_one rating to embed a multiple-choice question with a select only one answer setting.
  2. Specify a name and label for the 'select_one rating' question.
  3. Under the relevant column, specify the following formula:
${<targetQuestionName>}='<targetChoiceSelected>'
The code block below is an example of the full working formula.
${firstQues}='yes'
The edited XLSForm
  1. Click Save The Save icon .

The image below shows the additional questions embedded to a multiple-choice question when 'Yes' is selected.

The ArcGIS Survey123 Connect survey

Article ID: 000031366

Software:
  • ArcGIS Survey123 Connect

Receive notifications and find solutions for new or common issues

Get summarized answers and video solutions from our new AI chatbot.

Download the Esri Support App

Related Information

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options