BingoCardGenerator

BingoCardGenerator.gs

// the ID for the spreadsheet of quotes
var sheet_id = SpreadsheetApp.getActiveSpreadsheet().getId();
var sheet = SpreadsheetApp.openById(sheet_id);
var range = sheet.getDataRange();
var values = range.getValues();
var rows = range.getNumRows();

// Log some things for sanity check
Logger.log("sheet ID: " + sheet_id)
Logger.log("sheet: " + sheet)
Logger.log("range: " + range)
//Logger.log("values: " + values)
Logger.log("rows: " + rows)


// respond to HTTP POST requests
function doGet(e) {

  var possibilities = []
  for (var i=1; i < rows; i++) {
    possibilities.push(values[i][0])
  }
//  Logger.log(possibilities)
  
  var randomized = UnderscoreGS._shuffle(possibilities)
//  Logger.log(randomized)
  
  var bingoCard = "<div class='card'>\n"
  for (j=0;j<5;j++) {
    bingoCard += "<div class='row'>\n"
    for (k=0;k<5;k++) {
      bingoCard += "<div class='square'>" + randomized[k] + "</div>"
    }
    bingoCard += "\n</div>"
  }
  bingoCard += "\n</div>"

  Logger.log(bingoCard)
    
  var output = HtmlService.createHtmlOutput(bingoCard);
  return output;
}