How do I pipe / hide / mask options based on a previous Grid question? (Power Surveys)

Tip: Are you using scripting with power surveys to pipe/hide/mask answer options from one question to another question? You can now do this in surveys with no need for scripting. For more information, see Carry Forward Answers.

The term pipe, hide and mask are used interchangeably. The common goal is to show options based on a previous question. We will use the word mask throughout this article.

The question which you would like to reference will be referred to as the previous question. The question that will be masked will be referred to as the masking question.

This script will work in the following question types:

• Grid Question to Choice Question
• Grid Question to Grid Question - Rows
• Grid Question to Page Items

Previous Question Type	Masking Question Type
Single Choice Grids (standard and visual) Multi Choice Grids (standard and visual) Scale Slider Grids Single Choice Card Sorts: rows=cards Single Choice Magnetic Boards: rows=magnets Multi Choice Magnetic Boards: rows=magnets	Single Choice Questions (standard and visual) Multi Choice Questions (standard and visual) Single Choice Grids (standard and visual) Multi Choice Grids (standard and visual) Scale Slider Grids Single Choice Card Sorts: rows=cards Single Choice Magnetic Boards: rows=magnets Multi Choice Magnetic Boards: rows=magnets Allocation Grids Allocation Sliders Items on a page

Detailed Steps

Note: Make sure that the options in the previous question and in the masking question have the same number of items and are in the same order.

1. Copy the script from below.
2. Select the masking question/page in the Questionnaire Tree.
3. In the Scripting section of the masking question/page, click Edit Scripts.
4. Paste the script into the On Load tab.
5. Change Q_MASKING to the name of your masking question/page.
6. Change Q_PREVIOUS to the name of your previous question.
   Note: this can appear twice in the script depending on the case.
7. Change # to column/scale/bucket/board numbers (separated by a comma if multiple) of the previous question that must be selected in order to show up in masking question.
   Note: # represents the position of the column item, it is not the precode. If you specify multiple number in one list, the item will be displayed if one or more of these column # was selected in the previous grid row.
8. Change -1 to item numbers you would like to show all the time (separated by a comma if there are multiple). E.g. 'None of these' option. If you do not have any items to show permanently, leave it as is.
9. Click Save.
10. Validate and test your survey.

Script

/*
Script Name: How do I pipe / hide / mask options based on a previous Grid question? (Power Surveys)

To ensure your script works as expected, always copy the original script from the script library found in the support portal. Failure to use the most up to date script from the script library may cause unexpected results. 
*/

 

Show (Q_MASKING, ArrayUnion(GetRowsIfAnySelected(Q_PREVIOUS, new int[]{#}), new int[]{-1}));

Example

Show(Q2, ArrayUnion(GetRowsIfAnySelected(Q1, new int[]{4,5}), new int[]{-1}));

Q1


Q2

Do you anticipate that there will be cases where respondents are shown only one option as a result of masking?
The survey logic might end up forcing participants to select the only option or allocate 100% to the only option without any other choices (only in cases of masking question being a Single Choice question or an Allocation Grid). If you would like to skip the question and have the option auto-punched for this specific case, please follow further steps in this article to complete your script.