clemt’s gists

JuanCanham / gist:2917132

Created June 12, 2012 12:02

Simple Google Apps script to update signatures accross a domain

	function getSignature() {
	//pretty basic function for testing
	if ( startupChecks()) { return; }
	var email = SpreadsheetApp.getActiveSpreadsheet().getActiveCell().getValue().toString();
	if ( email === "" ) {
	Browser.msgBox("No email selected", "Please select a cell containing a user's email" , Browser.Buttons.OK);
	return;
	}
	var result = authorisedUrlFetch(email, {});
	Browser.msgBox(result.getContentText());

pamelafox / exportjson.js

Last active November 4, 2025 07:57

Google Spreadsheet JSON ExportHow-to at http://blog.pamelafox.org/2013/06/exporting-google-spreadsheet-as-json.html

	// Includes functions for exporting active sheet or all sheets as JSON object (also Python object syntax compatible).
	// Tweak the makePrettyJSON_ function to customize what kind of JSON to export.

	var FORMAT_ONELINE = 'One-line';
	var FORMAT_MULTILINE = 'Multi-line';
	var FORMAT_PRETTY = 'Pretty';

	var LANGUAGE_JS = 'JavaScript';
	var LANGUAGE_PYTHON = 'Python';

Simounet / index.html

Created February 19, 2012 11:56

Simple JS Popin

	<!DOCTYPE html>
	<html>
	<head>
	<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
	<title>Simple JS Popin</title>
	<link href="style.css" rel="stylesheet" type="text/css" />
	<script src="script.js" type="text/javascript"></script>
	</head>

	<body>

mhawksey / gist:1442370

Last active July 9, 2025 12:26

Google Apps Script to read JSON and write to sheet

	function getJSON(aUrl,sheetname) {
	//var sheetname = "test";
	//var aUrl = "http://pipes.yahoo.com/pipes/pipe.run?_id=286bbb1d8d30f65b54173b3b752fa4d9&_render=json";
	var response = UrlFetchApp.fetch(aUrl); // get feed
	var dataAll = JSON.parse(response.getContentText()); //
	var data = dataAll.value.items;
	for (i in data){
	data[i].pubDate = new Date(data[i].pubDate);
	data[i].start = data[i].pubDate;
	}

mhawksey / gist:1170597

Created August 25, 2011 13:02

Google Apps Script to fill in a Document template with Spreadsheet data

	function onOpen() {
	var menuEntries = [ {name: "Create Diary Doc from Sheet", functionName: "createDocFromSheet"}];
	var ss = SpreadsheetApp.getActiveSpreadsheet();
	ss.addMenu("Fitness Diaries", menuEntries);
	}

	function createDocFromSheet(){
	var templateid = "1O4afl8SZmMxMFpAiN16VZIddJDaFdeRBbFyBtJvepwM"; // get template file id
	var FOLDER_NAME = "Fitness Diaries"; // folder name of where to put completed diaries
	// get the data from an individual user

adressler / iframe-resize-cross-domains.html

Created April 15, 2011 10:20

Resize iFrames across domains

	<!-- taken from http://blog.johnmckerrell.com/2006/10/22/resizing-iframes-across-domains/ -->

	<!--
	My Domain
	the page that includes the iFrame
	-->
	<script>
	function updateIFrame(height) {
	var iframe = document.getElementById('myiframe');
	iframe.setAttribute('height', height);

mhawksey / gEVS.html

Created December 13, 2010 21:06

Example of using Google Spreadsheet and Visualization API as a multi question voting (clicker) system

	<!--
	You are free to copy and use this sample in accordance with the terms of the
	Apache license (http://www.apache.org/licenses/LICENSE-2.0.html)
	-->

	<!DOCTYPE html>
	<html lang="en">
	<head>
	<meta http-equiv="content-type" content="text/html; charset=utf-8"/>
	<title>gEVS Using Google Spreadsheet and Visualization API as a voting system wrapper</title>