How do I insert a text box in the last row of a standard Grid question? (Power Surveys)

This is a 2-part setup which involves first inserting a text box into the the last row, first column of one of the following standard Grid questions:

• Single Choice Grid
• Multi Choice Grid
• Rank Order Grid

The second script will then check the response selected in the last row of the grid. If there is a response, the respondent will be required to type something in the box. If there is no response, the box should be empty before continuing in the survey.

Notes:

• This script will not work for visual questions. It will also not work in mobile view because of the use of JavaScript.
• The script makes the last row optional.
• For Single Choice Grid, respondents is not allowed to deselect an item in the grid.

Detailed Steps

Adding and setting up the questions:

1. Click on the Questionnaire tab of your study.
2. Create a page.
3. Create your standard grid question within the page.
4. Deselect "Question completion required" in the properties of the grid question.
5. Create an open end question within the same page.
6. Remove the default instruction text from the open end question.
7. In the Properties section of the open end question, deselect "Question completion required".
8. In the Properties section of the open end question, change the "Width" property to 25.

Prepare the scripts in Notepad:

1. Open Notepad or a similar text editing tool.
2. Copy Script 1 below into Notepad.
3. Change GRIDNAME to the name of your standard grid question.
4. Change TEXTBOXNAME to the name of your open end question.
5. Save the completed script in Notepad.
6. Copy Script 2 below into Notepad.
7. Change GRIDNAME to the name of your standard grid question.
8. Change TEXTBOXNAME to the name of your open end question.
9. Save the completed script in Notepad.

Script 1:

<script src="https://static.visioncritical.net/prog/ext_libs/jquery/jquery-1.12.3.min.js"  
type="text/javascript"></script>
<SCRIPT src="https://static.visioncritical.net/prog/s1/js/common/common_v1.560.js">
/*

Script Name: How do I insert a text box to the last row of a standard grid question?

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. 

*/
</SCRIPT>


<SCRIPT> 
appendTextBoxToLastRow_Grid([%(GRIDNAME.Id)%],"[%(TEXTBOXNAME.Id)%]"); 
</SCRIPT> 

Script 2:

/*

Script Name: How do I insert a text box to the last row of a standard grid question?

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. 

*/

if (!IsATR){

  GridSequence gs = GRIDNAME;
  VerbatimQuestion vq = TEXTBOXNAME;

  // No need to edit below
  int other_row = gs.WorkflowSteps.Count;
  bool row_checked = false;
  bool other_answered = false;

  foreach(ShowQuestionAction sqa in gs.WorkflowSteps){
    ChoiceQuestion cq = (ChoiceQuestion)sqa.ChoiceQuestion;
    int i = sqa.OrderInParent+1;
	
    if ( (int)cq<1 && i!=other_row){
      NewError("Please enter a response for each row. The last row is optional.");
      break;
    }
    if ( (int)cq>0 && i==other_row){
      row_checked = true;
    }        
}

  if (vq.Value!=null) other_answered = true;

  if (row_checked==true && other_answered==false){
    NewError("Please type your response in the box provided.");
  }

  if (row_checked==false && other_answered==true){
    NewError("Please select a response for the last row (since you have typed something into the box).");
  }
}

Insert the completed scripts into the Script section of your Page:

1. Copy the completed Script 1 from Notepad.
2. Select the Page in the Questionnaire Tree.
3. In the Scripting section of the Page, click Edit Scripts.
4. Paste Script 1 into the JavaScript tab.
5. Paste Script 2 into the On Validate tab.
6. Click Save.
7. Validate and test your survey.

Notes:

• ATR will bypass the validation script, so please be aware that ATR data will not be accurate for this setup. It will need to be checked manually through the link.
• Please contact Technical Support if you would like to apply the scripts in a multi-language survey.

More Information

For more information, see these articles:

• Grids
• Rank Order Grid