Lynk-task

Code.js

// 0. create function called getNameSummary:  
// 1. get ui 
// 2. concat string and variable = 'string' + x
// 3. newline = '\n'
// 4. ui.alert
// 5. build from logPeople3 function
// 6. logPeople3 function accpet variable sheet passed from 'getNameSummary'
function getNameSummary() {
  var ui = SpreadsheetApp.getUi();
  var result = ""
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  for(var i = 0; i < spreadsheet.getSheets().length; i++){
    var sheet = spreadsheet.getSheets()[i]
    // Logger.log(sheet.getName())
    result += "\n" + sheet.getName() + "\n"
    result += "===================================" + "\n"
    result += logPeople3Updated(sheet)
  }
  // Logger.log(result)
  ui.alert(result)
}

function logPeople3Updated(sheet) {
  var name = ""
  var data = sheet.getDataRange().getValues();
  for (var i = 0; i < data.length; i++) {
    if(i >= 4){
      // Logger.log('name: ' + data[i][0]);
      name += "" + 'name: ' + data[i][0] + "\n"
    }
  }
  return name
}

// https://developers.google.com/apps-script/guides/triggers/
function onOpen() {
  SpreadsheetApp.getUi() // Or DocumentApp or FormApp.
      .createMenu('Lynk')
      .addItem('Show summary', 'getNameSummary')
      .addToUi();
}