Andrew Roberts andrewroberts

## LogAppsScriptConfig
/**
 * 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')

## EmailPDFOfFormSubmission.gs
/*

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:

## convertSpreadsheetToPdf.gs
/*
 * 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]
 */

## PDFCreator_EmailAllResponses
/*

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.

## StackTraces-Logging-GAS.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                andrewroberts
                / StackTraces-Logging-GAS.md
            
            
              Last active
              July 7, 2017 11:58
                — forked from hlecuanda/StackTraces-Logging-GAS.md
            
              
                Example using Stackdriver logging for debugging a custom function for sheets in Google Apps Script. / Writing a Caching custom function
              
          
    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


## PDFCreator_SendMultiplePDFs.gs
/*

PDF Creator - Send multiple PDFs
================================

On selecting a number of contiguous rows and clicking "Create PDFs > Create PDFs
for selected rows" this script constructs a PDF for each selected row in the
attached GSheet.

The value in the "File Name" column is used to name the file and - if there is a

## fillInHtmlTemplate.gs
/**
 * For each placeholder - "{{[placeholder]}}", strip out any HTML and replace
 * it with the appropriate key value. An example use of this could be using the
 * HTML from a draft GMail as a template.
 *
 * E.g. If the obect were:
 *
 * {PlaceHolder1: newValue}
 *
 * In the template "{{PlaceHolder1}}" would be replaced with "newValue" even

## API_.gs
// 34567890123456789012345678901234567890123456789012345678901234567890123456789

// JSHint - TODO
/* jshint asi: true */

(function() {"use strict"})()

// API_.gs
// =======
//

## createPDF_filename.gs
// dev: andrewroberts.net

// Replace this with ID of your template document.
var TEMPLATE_ID = ''

// var TEMPLATE_ID = '1wtGEp27HNEVwImeh2as7bRNw-tO4HkwPGcAsTrSNTPc' // Demo template
// Demo script - http://bit.ly/createPDF

// You can specify a name for the new PDF file here, or leave empty to use the
// name of the template. Placeholders can also be placed in here.

## Properties_.gs
// 34567890123456789012345678901234567890123456789012345678901234567890123456789

// JSHint - TODO
/* jshint asi: true */

(function() {"use strict"})()

// Properties_.gs
// ==============
//
	/**
	* 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')
	/*

	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:
	/*
	* 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]
	*/
	/*

	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.
	/*

	PDF Creator - Send multiple PDFs
	================================

	On selecting a number of contiguous rows and clicking "Create PDFs > Create PDFs
	for selected rows" this script constructs a PDF for each selected row in the
	attached GSheet.

	The value in the "File Name" column is used to name the file and - if there is a
	/**
	* For each placeholder - "{{[placeholder]}}", strip out any HTML and replace
	* it with the appropriate key value. An example use of this could be using the
	* HTML from a draft GMail as a template.
	*
	* E.g. If the obect were:
	*
	* {PlaceHolder1: newValue}
	*
	* In the template "{{PlaceHolder1}}" would be replaced with "newValue" even
	// 34567890123456789012345678901234567890123456789012345678901234567890123456789

	// JSHint - TODO
	/* jshint asi: true */

	(function() {"use strict"})()

	// API_.gs
	// =======
	//
	// dev: andrewroberts.net

	// Replace this with ID of your template document.
	var TEMPLATE_ID = ''

	// var TEMPLATE_ID = '1wtGEp27HNEVwImeh2as7bRNw-tO4HkwPGcAsTrSNTPc' // Demo template
	// Demo script - http://bit.ly/createPDF

	// You can specify a name for the new PDF file here, or leave empty to use the
	// name of the template. Placeholders can also be placed in here.