clemt’s gists

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>

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

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

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>

pamelafox / exportjson.js

Last active January 9, 2026 22:44

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

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());

crstamps2 / jsonPuller

Created July 14, 2012 15:22

A Google apps script to pull json from a spreadsheet

	function doGet(){
	var ss = SpreadsheetApp.openById("//key ommitted");
	return exportJSON(ss);
	}


	// Exports current sheet as JSON and displays in message box.
	function exportJSON(ss) {
	var sheet = ss.getSheetByName("sessions");
	var rowsData = getRowsData(sheet);

tommcfarlin / add-custom-post-type-menu.php

Created April 25, 2013 12:38

[WordPress] Add a custom post type menu as a child of an existing custom post type menu.

	<?php

	// Define the 'Portfolio' post type. This is used to represent galleries
	// of photos. This will be our top-level custom post type menu
	$args = array(
	'labels' => array(
	'all_items' => 'Gallery',
	'menu_name' => 'Portfolio',
	'singular_name' => 'Gallery',
	'edit_item' => 'Edit Gallery',

mogsdad / digest.js

Last active October 29, 2021 03:28

This Google Apps Script function returns a string representing the 16-byte MD5 digest of a given message. It was originally written as an answer to StackOverflow question http://stackoverflow.com/questions/16216868/get-back-a-string-representation-from-computedigestalgorithm-value-byte. It's been refactored to support adaptation to other digest …

	/**
	* Return string representation of MD5 digest of the given message.
	*
	* @param {String} message Message to be encoded.
	*
	* @return {String} 16-byte digest value
	*/
	function signMd5(message){
	return digest(Utilities.DigestAlgorithm.MD5, message);
	}