2018/04/25 gtug girls gas

custom_function_translate.gs

function translate(val) {
  if (val.map) {
    return val.map(translate);
  }
  return LanguageApp.translate(val, "en", "ja");
}

custom_menu_toast.gs

function onOpen(e) {
  var ui = SpreadsheetApp.getUi();
  var mainMenu = ui.createMenu("カスタムメニュー")
  .addItem("toast", "test")
  .addToUi()
  ;
}

function test() {
  SpreadsheetApp.getActive().toast("カスタムメニュー");
}

trigger_count_sheet.gs

function onOpen(e) {
  SpreadsheetApp.getActive().toast("シートの数: " + SpreadsheetApp.getActive().getSheets().length);
}

trigger_edit_to_yellow_row.gs

function onEdit(e) {
  e.range.getSheet().getRange(e.range.getRow() + ":" + e.range.getRow()).setBackground("yellow");
}