Max Makhrov Max-Makhrov

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

The sctipt was originally designed by Kanshi TANAIKE.

Please see the original script and instructions first.

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

	// AKfycbz7GZDZb3Yt1usqUkIu_lNOp4tW0xUKuFR9K_fIksIGuep2TeJ5RU0J


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

	function someImportantFunction() {
	// [ 1 ]. do some stuff
	//
	//
	//
	Logger.log('Success!');

	// [ 2 ]. Report the execution
	var recipient = '[email protected]'; // change!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
	//

	// 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) {

	$(".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')

	scriptencoding utf-8

	let s:calendar_list = [
	\ ['Australian Holidays', 'en.australian#[email protected]'],
	\ ['Austrian Holidays', 'en.austrian#[email protected]'],
	\ ['Brazilian Holidays', 'en.brazilian#[email protected]'],
	\ ['Canadian Holidays', 'en.canadian#[email protected]'],
	\ ['China Holidays', 'en.china#[email protected]'],
	\ ['Christian Holidays', 'en.christian#[email protected]'],
	\ ['Danish Holidays', 'en.danish#[email protected]'],

	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.

	/**
	* 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: [email protected] (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

	// 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;

	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/",