Is there a way to use a loop to set choices in a list item in google forms scripts? -


i have program i'm trying make takes data in spreadsheet , makes google form , im trying make 11 cells each populate 1 drop down list. there setchoices method , inside of createchoices cant have other kind of code inside make 11 choices loop each 1 being next string in array. if can think of other methods please let me know...

this code currently:

function onopen() {   var sheet = spreadsheetapp.getactivesheet();    var names = sheet.getrange(1, 1, 200);    var values = names.getvalues();    var number = 0    var count = 0;    var array = "'" + values[0] + "'";    while (values[count] != "") {     number++;     count++;     if (values[count] != "") {       array = array + ", " + "'" + values[count] + "'";     }   }    logger.log(number);   logger.log(array);   (var = 0; < number; i++) {     logger.log(values[i]);    }    var form = formapp.create("cleaners");    var formid = form.getid();    var dropdown1 = form.addlistitem();    dropdown1.settitle("choose cleaner:");    dropdown1.setchoices([     dropdown1.createchoice(values[0]),     dropdown1.createchoice(values[1]),     dropdown1.createchoice(values[2]),     dropdown1.createchoice(values[3]),     dropdown1.createchoice(values[4]),     dropdown1.createchoice(values[5]),     dropdown1.createchoice(values[6]),     dropdown1.createchoice(values[7]),     dropdown1.createchoice(values[8]),     dropdown1.createchoice(values[9]),     dropdown1.createchoice(values[10])   ]);  } 

when make dropdown dont want have go in , change amount of choices created if name added list.

//try replacing code //this code requires access each value in array "values" separately. dropdown1.settitle("choose cleaner:");  dropdown1.setchoices([     dropdown1.createchoice(values[0]),     dropdown1.createchoice(values[1]),     dropdown1.createchoice(values[2]),     dropdown1.createchoice(values[3]),     dropdown1.createchoice(values[4]),     dropdown1.createchoice(values[5]),     dropdown1.createchoice(values[6]),     dropdown1.createchoice(values[7]),     dropdown1.createchoice(values[8]),     dropdown1.createchoice(values[9]),     dropdown1.createchoice(values[10])   ]);  // code //this code allows access entire array //if values = ['cleaner1', 'cleaner2', 'cleaner3', ...] //all of values accessed drowdown1.setchoicevalues(values); //setchoicevalues(values); doing .setchoicevalues(['cleaner1', 'cleaner2', 'cleaner3', ...]); //where values array dropdown1.settitle("choose cleaner:")          .setchoicevalues(values); 

Comments

Popular posts from this blog

sql - VB.NET Operand type clash: date is incompatible with int error -

SVG stroke-linecap doesn't work for circles in Firefox? -

python - TypeError: Scalar value for argument 'color' is not numeric in openCV -