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
Post a Comment