htmlcaller.gs

var enemy = "";
var map = "";
var side = "";

function doGet(e) {
  enemy = (e.parameter.enemy == undefined) ? "" : e.parameter.enemy;
  map = (e.parameter.map == undefined) ? "" : e.parameter.map;
  side = (e.parameter.side == undefined) ? "" : e.parameter.side;
  return HtmlService.createTemplateFromFile("index").evaluate();
}

function findData(){
  var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("フォームの回答 1");
  var last_row = sheet.getLastRow();
  var last_column = sheet.getLastColumn();
  var range = sheet.getRange(1, 1, last_row, last_column).getValues();
  var str = "";
  for(var i = last_row - 1; 0 < i ; i--){
    if((enemy == "" || range[i][2] == enemy) && (map == "" || range[i][3] == map) && (side == "" || range[i][4].indexOf(side) != -1)){
      str += "<tr><td>" + Utilities.formatDate(range[i][0], "Asia/Tokyo", "M/d HH:mm") + "</td>";
      for(var j = 1; j < last_column; j++)str += "<td>" + range[i][j] + "</td>";
      str += "</tr>";
    }
  }
  return str;
}

function include(filename) { return HtmlService.createHtmlOutputFromFile(filename).getContent(); }