Google-apps-script – Google FormsApp: Change item based on answer

google-apps-scriptgoogle-forms

Is it possible to change item, in my case – checkbox, based on user answer?

For example, I have Date item, where user have to put his/her birthday, and then if user is born on 2001 or later, then add two more options to checkbox item on current or next page.

Best Answer

You need to use "Multiple choice" or "Choose from a list" and then check "Go to page based on answer". Now you need to create a page break and place your extra two options there (Add item > Page break). Then after each choice in the original page, you need to select the page you created. Therefore when the user selects that choice he will be redirected to the page you just created.

Related Solutions

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.

Google Forms – How to Set Up Conditional Branching with Checkboxes

Short answer

Google Forms doesn't have the workflow controls that you are looking for.

Explanation

Google Forms has a way to set the next question page to be shown, but this only works for dropdown and multiple choice (radio button) questions.