i trying populate google form questions scraped google sheet. when run code getting questions created, 25% or have string, rest blank. questions appear correctly change every time run script. seemingly random.
function formpopulation() { var ss = spreadsheetapp.openbyid("--"); var sheet = ss.getsheetbyname('tracker'); var audittool = ss.getsheetbyname('audit tool'); var validatorinfo = ss.getsheetbyname('validator info'); //sheet info var rows = audittool.getlastrow(); //number of rows var columns = audittool.getlastcolumn(); //number of columns var startrow = 1; var startcolumn = 1; var datarange = audittool.getrange(startrow, startcolumn, rows, columns); //getrange(first row of data, first column of data, last row of data, last column of data) var data = datarange.getvalues(); //sets working range of script var form = formapp.openbyid("--"); var item = form.addlistitem(); var entityname = ""; var arrayofentities = []; var newentity = ''; (var = 4; < columns; i++) { //4 because entity names begin entityname = data[i][2]; logger.log('entityname: ' + entityname); newitem = item.createchoice(entityname); arrayofentities.push(newitem); }; item.settitle("select entity").setchoices(arrayofentities); var requirement = ""; var arrayofrequirements = []; var newrequirement = ''; (var j = 5; j < rows; j++) { //5 because requirements begin if (data[0][j] != null) { requirement = data[0][j]; if (requirement != "" || requirment != null){ requirement = "question #" + j; logger.log('requirement: ' + requirement); form.addmultiplechoiceitem().settitle(requirement).setchoicevalues(['complete', 'incomplete']); }; }; }; }; the first question supposed multiple choice item each 'entity' option. remainder of questions supposed whether each 'requirement' marked complete or incomplete. here spreadsheet working from
you have typo: if (requirement != "" || requirment != null){
should 'requirement'
Comments
Post a Comment