Google-apps-script – Google Forms – App script won’t iterate through all form fields

google-apps-scriptgoogle-forms

I have made a Google Form and onSubmit an app script will run iterating through all form questions and answers however some questions, when the corresponding answer is left empty, are not listed/available in the iteration. Nevertheless, many questions whose answer is empty, are "listed" in the iteration.

function onSubmit(e) { var items = e.response.getItemResponses(); var emailBody = ''; for (i in items){ // the follwoing will not iterate all questions emailBody+= "<br/>"+ items[i].getItem().getTitle()+": "+items[i].getResponse(); } ......... other code follows ..... }

Best Answer

I think I got it! Items being left out from the list are checkboxes with no answer... from the Google documentation:

getItemResponses() Gets all item responses contained in a form response, in the same order that the items appear in the form. If the form response does not contain a response for a given TextItem, DateItem, TimeItem, or ParagraphTextItem, the ItemResponse returned for that item will have an empty string as the response. If the form response omits a response for any other item type, this method excludes that item from its returned array.

Related Solutions

Google-forms – How to add a multiple choice question requiring a single selection

To get Radio Buttons on a Google Docs Form, you need set the Question Type to Multiple Choice

Google Docs Forms - Radio Buttons

Google-sheets – How to report which checkboxes were left unchecked on a Google Forms submission

Still don't have a solution for how to directly get values of unchecked checkboxes, but I was at least able to write a function that compares the correct answer to the submission.

This splits the correct answer into an array then compares each item to the submission:

function checkAnswer(answer, key) {
var kArray = key.split(', ');
var nArray = [];
for (i=0; i<kArray.length; i++) {
    if (answer.indexOf(kArray[i]) == -1) {
        nArray.push(kArray[i]);
    }
}
return nArray.join(", ");
}

Then I could call it every time I needed to report the boxes left unchecked. For example, with the doors question:

if (doors != correctDoors) {
  var doorsMessage = "Unlocked: " + checkAnswer(doors, correctDoors);
  report.push(doorsMessage);
}

At the end, I'll compile the report with:

report.join("\n");

And voila! The best I could do...

Ultimately, I'm still looking for how to directly get the unchecked boxes if anyone has a solution.

Best Answer

Related Solutions

Google-forms – How to add a multiple choice question requiring a single selection

Google-sheets – How to report which checkboxes were left unchecked on a Google Forms submission

Related Topic