Employee Self-Service Record Lookup

This script was also duplicated for each of the Google Sheets serving as employee records for minor things. This script example came from the Gear Issue History which showed the employees what gear they have been issued, when, when it was returned, etc.

var sheetID = 'YOUR SHEET ID HERE'; // enter the Spreadsheet ID
var dataSheet = 'Gear Log'; // enter the name of the sheet that contains ALL user data
var emailHeader = 'Email'; // replace this with the header name (per Row 1) where user emails exist

/* ========== DO NOT EDIT BELOW THIS LINE ========== */

var activeUser = Session.getActiveUser();
var ss = SpreadsheetApp.openById(sheetID);

function doGet(e) {
  return HtmlService.createHtmlOutputFromFile('Index').setTitle('My Issued Stuff');
}

function currentUser() {
  if (activeUser !== '') {
    return activeUser.getEmail();
  } else {
    return "Couldn't detect user!!!";
  }
}

function getData() {
  var sheetName = dataSheet;
  var activeSheet = ss.getSheetByName(sheetName);
  var values = activeSheet.getDataRange().getDisplayValues();
  var header = values[0];
  var emailIndex = header.indexOf(emailHeader);
  var userData = [];
  for (var i = 0; i < values.length; i++) {
    if (values[i][emailIndex] == activeUser) {
      userData.push(values[i].slice(0,12));
    }
  }
  if (userData.length > 0) {
    var tableStart = '\n<table class="responsive-table">';
    var tableHead = '\n<thead>\n<tr>';
    for (var j = 0; j < 12; j++) {
      tableHead = tableHead + '\n<th>' + header[j] + '</th>';
    }
    tableHead = tableHead + '\n</tr>\n</thead>';
    var tableBody = '\n<tbody>';
    for (var k = 0; k < userData.length; k++) {
      tableBody = tableBody + '\n<tr>';
      for (var l = 0; l < userData[0].length; l++) {
        tableBody = tableBody + '\n<td>' + userData[k][l] + '</td>';
      }
      tableBody = tableBody + '\n</tr>\n';
    }
    var tableEnd = '</tbody>\n</table>';
    var tableHtml = tableStart + tableHead + tableBody + tableEnd;
    return tableHtml;
  } else {
    return '<table class="table"><tbody><tr><td>No data found.</td></tr></tbody></table>';
  }
}