lynk-101

Code-practice.js

function logPeople1() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var data = sheet.getDataRange().getValues();
  for (var i = 0; i < data.length; i++) {
    Logger.log('name: ' + data[i][0]);
  }
}

function logPeople2() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var data = sheet.getDataRange().getValues();
  for (var i = 0; i < data.length; i++) {
    if(i >= 4){
      Logger.log('name: ' + data[i][0]);
    }
  }
}

function addPeople() {
  var sheet = SpreadsheetApp.getActiveSheet();
  sheet.appendRow(["Mike"]);
}

// https://developers.google.com/apps-script/reference/base/prompt-response
function addPeople2() {
  var sheet = SpreadsheetApp.getActiveSheet();
  // Display a dialog box with a title, message, input field, and "Yes" and "No" buttons. The
  // user can also close the dialog by clicking the close button in its title bar.
  var ui = SpreadsheetApp.getUi();
  var response = ui.prompt('Getting to know you', 'May I know your name?', ui.ButtonSet.YES_NO);
  
  var username = ''
  // Process the user's response.
  if (response.getSelectedButton() == ui.Button.YES) {
    Logger.log('The user\'s name is %s.', response.getResponseText());
    username = response.getResponseText()
  } else if (response.getSelectedButton() == ui.Button.NO) {
    Logger.log('The user didn\'t want to provide a name.');
  } else {
    Logger.log('The user clicked the close button in the dialog\'s title bar.');
  }
 
  sheet.appendRow([username]);
}

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