andrewroberts

// Memset/OpenStack API
// --------------------

// Include the GAS OpenStack library - Mo6MqgzKidu5VYzZ7NzIM-tnfWGfgtIUb

// Complete these fields appropriately for your storage provider

var OPENSTACK_ROOT_URL = '[URL of storage using OpenStack API]' // e.g. 'https://auth.storage.memset.com/v2.0/'
var OPENSTACK_USERNAME = '[Enter username here]'

andrewroberts

// 34567890123456789012345678901234567890123456789012345678901234567890123456789

/**
 * @fileOverview GAS Library for accessing an <a href="http://developer.openstack.org/api-ref.html">OpenStack API</a>. Library ID - Mo6MqgzKidu5VYzZ7NzIM-tnfWGfgtIUb
 * @author <a href="mailto:andrew@roberts.net">Andrew Roberts</a>
 * @copyright <a href="http://www.andrewroberts.net">Andrew Roberts</a>
 */

/*
 * This program is free software: you can redistribute it and/or modify it under

andrewroberts

var VALID_COLUMN_INDEX = 4
var EMAIL_COLUMN_INDEX = 3

function onOpen() {
  SpreadsheetApp
    .getUi()
    .createMenu('Validate Emails')
    .addItem('Validate Sheet', 'validateEmail')
    .addToUi()
}

andrewroberts

Logging custom functions using stackdriver in google apps script

Recently, console logging became available for Google Apps Script projects. It used to be impossible to use the Log service that comes with the GAS runtime, but now all you need to do is throw an exception. Exceptions get logged in stackdriver logging and when enabled, unhandled exceptions will not stop your script execution. This adds up to nearly 0 lag if you are using this feature (?) by purposely throwing exceptions, and you can get creative with your error message to avoid having to expand stackdriver's log messages (which are pretty comprehensive stacktraces!)

Setup

andrewroberts

function getTrialBalancesWithNoDate() {
  
  // .
  // .
  // .

  fetchPublicAppData('Reports/TrialBalance', '', '') // OK
  
  // .
  // .

andrewroberts

function GET_ADDRESS(placeName) {
  var response = Maps.newGeocoder().geocode(placeName);
  return response.results[0].formatted_address 
}

andrewroberts

function onOpen() {

  SpreadsheetApp
    .getUi()
    .createMenu('Terrain')
    .addItem('Generate terrain map', 'createTerrain')
    .addToUi();
}

andrewroberts

/*

PDF Create - with rename and email
==================================

When you click "Create PDF>Create PDF" this script uses the data from 
the active row to construct a PDF in your GDrive. The value in the 
"File Name" column is used to name the file and - if there is a 
value - it is emailed to the recipient in the "Email" column.

andrewroberts

// 34567890123456789012345678901234567890123456789012345678901234567890123456789

// JSHint: 22 March 2015 08:56 GMT
// Unit Tests: 22 March 2015 08:50 GMT

/*
 * Copyright (C) 2015-2017 Andrew Roberts (andrew@roberts.net)
 * 
 * This program is free software: you can redistribute it and/or modify it under
 * the terms of the GNU General Public License as published by the Free Software

andrewroberts

function testNumber() {
  var value = 1234.56789
  var a = format(value, {numberOfDecimalPlaces: 2})
  debugger
}

function testDate() {
  var value = new Date()
  var a = format(value)