ttsukagoshi

const CONFIG = {
  'sheetName': 'Choices', // Name of sheet
  'cellFormUrl': { 'rowNum': 4, 'colNum': 2 }, // Row and column numbers of the cell that designates the URL of Google Form.
  'rangeOffsetChoices': { 'rowNum': 6, 'colNum': 3 }, // Left- and upper-most cell of the range in which choices are listed.
  'timestampItemTitle': '最終更新日時' // Title of the item in the target Google Form that denotes the timestamp of which the form was last updated.
};

function onOpen() {
  SpreadsheetApp.getUi()
    .createMenu('Choice Editor')

ttsukagoshi

How to Use

1. Prepare a copy of the code in the localized-message.js, setting MESSAGES to suit your needs.
2. To call a message,

// Get user locale
var locale = Session.getActiveUserLocale();

or alternatively, if you are creating a script bound to a Google Docs file (e.g., a Google Sheets file),

var locale = SpreadsheetApp.getActiveSpreadsheet().getSpreadsheetLocale();

ttsukagoshi

/**
 * Gets the cells' height and width in pixels for the selected range in Google Spreadsheet in form of a 2-d JavaScript array;
 * the array values are ordered in the same way as executing Range.getValues()
 * @param {Object} activeSheet The active Sheet class object in Google Spreadsheet, e.g., SpreadsheetApp.getActiveSheet()
 * @param {Object} activeRange The selected Range class object in Google Spreadsheet, e.g., SpreadsheetApp.getActiveRange()
 */
function cellPixSizes(activeSheet, activeRange) {
  var rangeStartCell = { 'row': activeRange.getRow(), 'column': activeRange.getColumn() };
  var cellValues = activeRange.getValues();
  var cellPixSizes = cellValues.map(function(row, rowIndex) {

ttsukagoshi

const RECORDING_SHEET_NAME = 'SHEET_NAME'; // Sheet name to record the timestamp.
const RECORDING_CELL = {'row': 2, 'column': 2}; // Row and column number of the cell to record the timestamp.

/**
 * Automatic timestamp for the latest update on this spreadsheet.
 */
function onEdit() {
  var now = new Date();
  var timestamp = now.toISOString();
  SpreadsheetApp.getActiveSpreadsheet()

ttsukagoshi

/**
 * Delete all sheets in this spreadsheet except for the designated sheet IDs
 * @param {Array} exceptionSheetIds [Optional] Array of sheet IDs to not delete
 */
function deleteSheets(exceptionSheetIds) {
  exceptionSheetIds = exceptionSheetIds || [];
  const ss = SpreadsheetApp.getActiveSpreadsheet();
  const sheets = ss.getSheets();
  for (var i = 0; i < sheets.length; i++) {
    var sheet = sheets[i];

ttsukagoshi

/**
 * Google App Script to check the iCalID of a specific Google Calendar event.
 * You need to have access to the Google Calendar, as designated by the Google Calendar ID
 */
function checkICalId() {
  var calendarId = '[email protected]';
  var startTime = new Date('2020-01-18T17:15+0900');
  var endTime = new Date('2020-01-18T17:15+0900');
  var events = CalendarApp.getCalendarById(calendarId).getEvents(startTime, endTime);
  for (var i = 0; i < events.length; i++) {

ttsukagoshi

/**
 * Script for the original Google App Script from which you want to export the script properties.
 * Shows in the log the script properties in JSON-encoded object; use with scriptPropertiesImport() described below
 */
function scriptPropertiesExport() {
  var properties = JSON.stringify(PropertiesService.getScriptProperties().getProperties());
  Logger.log(properties);
}

ttsukagoshi

/**
 * Returns the maximum value in a designated column
 * @param {sheet} sheet Target sheet
 * @param {number} numCol Column number of target column
 * @param {number} initialValue Initial value
 * @return {number} max The largest number in target column
*/
function getMax(sheet, numCol, initialValue) {
  initialValue = initialValue || 0;
  var data = sheet.getRange(2, numCol, sheet.getLastRow()-1).getValues(); // First row of sheet used as header row

ttsukagoshi

/**
 * Create Google Spreadsheet sheet(s) from set(s) of header and value
 * 
 * @param {Object} spreadsheet - Spreadsheet object to create sheet on 
 * @param {Array} dataSet - Array of formatted object containing data object(s) which should be in form of 
 * [
 *     {'sheetName':{string}'sheetName0', 'sheetData':{Array}dataObject0},
 *     {'sheetName':{string}'sheetName1', 'sheetData':{Array}dataObject1},...
 * ]
 * @param {string} prefix - Optional. Prefix to be added to title of each sheet.

ttsukagoshi

/**
 * Function to create a Google Spreadsheet in a particular Google Drive folder
 * @param {Object} targetFolder - Google Drive folder object in which you want to place the spreadsheet
 * @param {string} ssName - name of spreadsheet 
 * @return {string} ssId - spreadsheet ID of created spreadsheet
 */
function createSpreadsheet_(targetFolder, ssName) {
  var ssId = SpreadsheetApp.create(ssName).getId();
  var temp = DriveApp.getFileById(ssId);
  targetFolder.addFile(temp);