Student Feedback Form

Source Code

function myFunction() {
  // What period is it?
  var period = 1;
  // How many groups are there?
  var groups = 5;
  
  var sheet = SpreadsheetApp.create('Student Feedback Forms - Period ' + period);
  sheet.getRange('A1').setValue('Group #');    
  sheet.getRange('B1').setValue('Published URL');
  sheet.getRange('C1').setValue('Edit URL');
  var spreadSheetRowNumber = 2;
  
  // use a loop to create each Google Form  
  for (x = 1; x <= groups; x++) {
    var form = FormApp.create('Period ' + period + ' - Group ' + x);
    var item = form.addMultipleChoiceItem();
      item.setTitle('Did the App behave per the specifications they listed in their CSP 3.4 Worksheet?');
      item.setChoiceValues(['Yes','No']);
    form.addMultipleChoiceItem()
      .setTitle('Did you find any bugs? Was there anything confusing or broken?')
      .setChoiceValues(['Yes','No']);
    form.addParagraphTextItem()
      .setTitle('If yes, what were they?');
    form.addParagraphTextItem()
      .setTitle('What did you like about their App?');
    form.addParagraphTextItem()
      .setTitle('What are your recommendations on improving their App?');
    
    // Push these values to a Google Sheet for easy reference
    // cast the spreadSheetRowNumber to a string
    n = spreadSheetRowNumber.toString();
    sheet.getRange('A' + n).setValue(x);    
    sheet.getRange('B' + n).setValue(form.getPublishedUrl());
    sheet.getRange('C' + n).setValue(form.getEditUrl());
    // increment the spreadSheetRowNumber
    spreadSheetRowNumber += 1;
  }
}

Last updated

Was this helpful?