Skip to main content
title, body text, added tag
Source Link
Jacob Jan
  • 23.3k
  • 16
  • 106
  • 195

How do I create a multiple choice question in a Google formForms based on spreadsheet data?

I am making a Google Form for evaluations. I will have a multiple choice question in there and the available options have to come from a list of items, say on a spreadsheet or a text document. I have figured out that I can create question using:

form.addMultipleChoiceItem()
 .setTitle('Do you prefer cats or dogs?')
 .setChoiceValues(['Cats','Dogs'])
 .showOtherOption(true);

However, how do I make it so that the list of choices come from a spreadsheetGoogle Spreadsheet?

How do I create a multiple choice question in a Google form based on spreadsheet data?

I am making a Google Form for evaluations. I will have a multiple choice question in there and the available options have to come from a list of items, say on a spreadsheet or a text document. I have figured out that I can create question using:

form.addMultipleChoiceItem()
.setTitle('Do you prefer cats or dogs?')
.setChoiceValues(['Cats','Dogs'])
.showOtherOption(true);

However, how do I make it so that the list of choices come from a spreadsheet?

How do I create a multiple choice question in Google Forms based on spreadsheet data?

I am making a Google Form for evaluations. I will have a multiple choice question in there and the available options have to come from a list of items, say on a spreadsheet or a text document. I have figured out that I can create question using:

form.addMultipleChoiceItem()
 .setTitle('Do you prefer cats or dogs?')
 .setChoiceValues(['Cats','Dogs'])
 .showOtherOption(true);

However, how do I make it so that the list of choices come from a Google Spreadsheet?

Tweeted twitter.com/#!/StackWebApps/status/413848627950678016
Title
Link
Vidar S. Ramdal
  • 17.4k
  • 11
  • 71
  • 82

How do I create a multiple choice question in a Google form based on list ofspreadsheet data?

deleted 11 characters in body
Source Link
ale
  • 52.9k
  • 42
  • 165
  • 314

I am making a Google Form for evaluations. I will have a multiple choice question in there and the available options have to come from a list of items, say on a spreadsheet or a text document. I have figured out that I can create question using:

form.addMultipleChoiceItem() .setTitle('Do you prefer cats or dogs?') .setChoiceValues(['Cats','Dogs']) .showOtherOption(true);

form.addMultipleChoiceItem()
.setTitle('Do you prefer cats or dogs?')
.setChoiceValues(['Cats','Dogs'])
.showOtherOption(true);

However, how do I make it so that the list of choices come from a spreadsheet?

Cheers Subhi

I am making a Google Form for evaluations. I will have a multiple choice question in there and the available options have to come from a list of items, say on a spreadsheet or a text document. I have figured out that I can create question using:

form.addMultipleChoiceItem() .setTitle('Do you prefer cats or dogs?') .setChoiceValues(['Cats','Dogs']) .showOtherOption(true);

However, how do I make it so that the list of choices come from a spreadsheet?

Cheers Subhi

I am making a Google Form for evaluations. I will have a multiple choice question in there and the available options have to come from a list of items, say on a spreadsheet or a text document. I have figured out that I can create question using:

form.addMultipleChoiceItem()
.setTitle('Do you prefer cats or dogs?')
.setChoiceValues(['Cats','Dogs'])
.showOtherOption(true);

However, how do I make it so that the list of choices come from a spreadsheet?

Source Link
Subhi
  • 41
  • 1
  • 1
  • 2
Loading