andrewroberts

/*

PDF Creator - Email all responses
=================================

When you click "Create PDF > Create a PDF for each row" this script 
constructs a PDF for each row in the attached GSheet. 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

/*
 * Save spreadsheet as a PDF
 *
 * Based on Dr.Queso's answer in http://stackoverflow.com/questions/30367547/convert-all-sheets-to-pdf-with-google-apps-script/30492812#30492812
 *
 * @param {String} email Where to send the PDF [OPTIONAL] 
 * @param {String} spreadsheetId Or the active spreadsheet[OPTIONAL]
 * @param {String} sheetName The tab to output [OPTIONAL]
 * @param {String} PdfName [OPTIONAL]
 */

andrewroberts

/*

PDF Create - Email on form submit
=================================

This script creates a PDF populated with the values submitted in a 
Google form.

The "on form submit" trigger needs to be manually created: 

andrewroberts

/**
 * Clear all of the config
 */

function clearConfig() {

  Logger.log('Delete Local Script Properties:')  
  if (PropertiesService.getScriptProperties() !== null) {
    Logger.log(PropertiesService.getScriptProperties().deleteAllProperties())
    Logger.log('  Deleted')

andrewroberts

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

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

andrewroberts

// 34567890123456789012345678901234567890123456789012345678901234567890123456789

// JSHint - 27 Feb 2016 21:19
/* jshint asi: true */

/*
 * Copyright (C) 2016 Andrew Roberts
 * 
 * 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

/*

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

var VALID_COLUMN_INDEX = 4
var EMAIL_COLUMN_INDEX = 3

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

andrewroberts

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

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