Max-Makhrov

// TODO
//  1. test
//  2. error handler
//  3. instructions on trigger installation

// AKfycbz7GZDZb3Yt1usqUkIu_lNOp4tW0xUKuFR9K_fIksIGuep2TeJ5RU0J


// the script assumes this structure of historic table:
//  ______________________________________

Max-Makhrov

function someImportantFunction() {
  // [ 1 ]. do some stuff
  //
  //
  //
  Logger.log('Success!');
  
  // [ 2 ]. Report the execution
  var recipient = 'makhrov.max@gmail.com'; // change!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
  //

Max-Makhrov

// The function may be used to prevent conflicting launches
function test_PreventConflict() {
  // Lock(1). Use Script memory
  var key = 'any-key-you-want';
  var mem = PropertiesService.getScriptProperties();
  
  
  // Lock(2). Check if other instance of the code is running
  var from = mem.getProperty(key);
  if (from) {

Max-Makhrov

$(".checklist-item").map(function(i, item) { 
	let text = $(item).find(".checklist-item-details-text").text(); 
	if( $(item).hasClass("checklist-item-state-complete") ) {
		text += " (DONE)";
    }
	return text;
}).get().join('\n')

Max-Makhrov

scriptencoding utf-8

let s:calendar_list = [
      \ ['Australian Holidays', 'en.australian#holiday@group.v.calendar.google.com'],
      \ ['Austrian Holidays', 'en.austrian#holiday@group.v.calendar.google.com'],
      \ ['Brazilian Holidays', 'en.brazilian#holiday@group.v.calendar.google.com'],
      \ ['Canadian Holidays', 'en.canadian#holiday@group.v.calendar.google.com'],
      \ ['China Holidays', 'en.china#holiday@group.v.calendar.google.com'],
      \ ['Christian Holidays', 'en.christian#holiday@group.v.calendar.google.com'],
      \ ['Danish Holidays', 'en.danish#holiday@group.v.calendar.google.com'],

Max-Makhrov

function launchTheForm_() {
  // create a form-template object
  let html = HtmlService.createTemplateFromFile('form').evaluate().setWidth(650).setHeight(1331);  
  // show the form to user
  SpreadsheetApp.getUi().showModalDialog(html, ' ');    
}

function onOpen() {
  var ui = SpreadsheetApp.getUi();
  // Or DocumentApp or FormApp.

Max-Makhrov

/**
* Invokes a function, performing up to 5 retries with exponential backoff.
* Retries with delays of approximately 1, 2, 4, 8 then 16 seconds for a total of 
* about 32 seconds before it gives up and rethrows the last error. 
* See: https://developers.google.com/google-apps/documents-list/#implementing_exponential_backoff 
* <br>Author: peter.herrmann@gmail.com (Peter Herrmann)
<h3>Examples:</h3>
<pre>//Calls an anonymous function that concatenates a greeting with the current Apps user's email
var example1 = GASRetry.call(function(){return "Hello, " + Session.getActiveUser().getEmail();});
</pre><pre>//Calls an existing function

Max-Makhrov

// usage
function cars_importRef() {
  var t = new Date();
  // YOUR CODE
  Browser.msgBox('Done! The time to run function is ' + getTimeEllapse_(t));
}

function getTimeEllapse_(t)
{
  var dif = new Date() - t;

Max-Makhrov

function test_xmlToJson(xmlString) {
  var xmltext = '<ALEXA VER="0.9" URL="davidwalsh.name/" HOME="0" AID="="><SD TITLE="A" FLAGS="" HOST="davidwalsh.name"><TITLE TEXT="David Walsh Blog :: PHP, MySQL, CSS, Javascript, MooTools, and Everything Else"/><LINKSIN NUM="1102"/><SPEED TEXT="1421" PCT="51"/></SD><SD><POPULARITY URL="davidwalsh.name/" TEXT="7131"/><REACH RANK="5952"/><RANK DELTA="-1648"/></SD></ALEXA>';
  var xml = XmlService.parse(xmltext); 
  Logger.log(JSON.stringify(xmlToJson_(xml)));
  // returns this:  
  //{
  //   "ALEXA":{
  //      "@attributes":{
  //         "VER":"0.9",
  //         "URL":"davidwalsh.name/",

Max-Makhrov

Upload image from your Computer to Google Drive using HTML-form. Show image via URL (IMAGE function) in your Spreadsheet

About the script

The sctipt was originally designed by Kanshi TANAIKE.

Please see the original script and instructions first.

Script : Google Apps Script