GAS事始め(その3)：Simple Triggersサンプル

SimpleTriggersSample.gs

function onOpen() {
  SpreadsheetApp.getUi()
      .createMenu('Get Energy Drink!')
      .addItem('Redbull', 'redbullSelected')
      .addItem('Monster', 'monsterSelected')  
      .addToUi();
}

function onEdit(e) {
  var r1 = e.range;
  var r2 = SpreadsheetApp.getActiveSheet().getRange("A2");
  r2.setValue("Edited: " + r1.getA1Notation() + ", value = " + r1.getValue());
}

function redbullSelected() {
  var range = SpreadsheetApp.getActiveSheet().getRange("A1");
  range.setValue("I want Redbull!");
}

function monsterSelected() {
  var range = SpreadsheetApp.getActiveSheet().getRange("A1");
  range.setValue("I want Monster!");
}