Skip to content

Instantly share code, notes, and snippets.

View tariqhamid's full-sized avatar

tariqhamid

41 followers · 200 following
  • London, UK
View GitHub Profile
@tariqhamid
tariqhamid / Calendar Copier.md
Created June 21, 2016 17:50 — forked from mogsdad/Calendar Copier.md

Calendar Copier

This Google Apps Script runs in a spreadsheet, where it prompts the user for the identity of two calendars, and a range of dates, then copies the corresponding events from one calendar to the other.

Caveats

This script is incomplete, ignoring a number of event attributes. (Feel free to enhance it, if you wish!) There are also some known issues:

  • All Day Events aren't really all day events. The createAllDayEvent() method should take care of this, but doesn't. Google Bug.
  • Recurrence isn't supported. (You can't find out the recurrence of existing events, so cannot recreate it.)
@tariqhamid
tariqhamid / SheetConverter.md
Created June 21, 2016 17:50 — forked from mogsdad/SheetConverter.md
Inspired by StackOverflow question http://stackoverflow.com/questions/18600638/google-script-copy-to-clipboard-and-mailto-questions.

SheetConverter library (formerly "Spreadsheet to HTML")

This is the source repository for the SheetConverter Google Apps Script library.

Libary documentation is available here.

Caveats

This script is incomplete, ignoring some types of formatting. (Feel free to fork and enhance it, if you wish! Broadly applicable enhancements can be merged and the library updated) There are also some known issues:

@tariqhamid
tariqhamid / Dashboard-Stylesheet.html
Created June 21, 2016 18:00 — forked from mogsdad/Dashboard-Stylesheet.html
Stylesheet for dashboard demo. (https://mogsdad.wordpress.com/2015/07/19/converting-from-uiapp-chart-service-to-html-service-google-visualization-api/)
<!-- This CSS package applies Google styling; it should always be included. -->
<link rel="stylesheet" href="https://ssl.gstatic.com/docs/script/css/add-ons.css">
<style>
.result-display {
margin-left: 15px;
font-size: 125%;
}
.error {
@tariqhamid
tariqhamid / Dashboard-JavaScript.html
Created June 21, 2016 18:02 — forked from mogsdad/Dashboard-JavaScript.html
Client-side JavaScript for dashboard demo. (https://mogsdad.wordpress.com/2015/07/19/converting-from-uiapp-chart-service-to-html-service-google-visualization-api/)
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script>
// Load the Visualization API and desired package(s).
google.load('visualization', '1.0', {'packages':['controls']});
/**
* Run initializations on dialog load.
*/
@tariqhamid
tariqhamid / Dashboard-Index.html
Created June 21, 2016 18:04 — forked from mogsdad/Dashboard-Index.html
Client-side HTML for dashboard demo. (https://mogsdad.wordpress.com/2015/07/19/converting-from-uiapp-chart-service-to-html-service-google-visualization-api/)
<!-- Use a templated HTML printing scriptlet to import common stylesheet. -->
<?!= HtmlService.createHtmlOutputFromFile('Stylesheet').getContent(); ?>
<html>
<body>
<h1 id="main-heading">Loading...</h1>
<div id="dashboard-div">
<div id="control-div">
<div id="slider-div">
</div>
<div id="selector-div">
@tariqhamid
tariqhamid / Dashboard-Code.gs
Created June 21, 2016 18:10 — forked from mogsdad/Dashboard-Code.gs
Server-side Google Apps Script for dashboard demo. (https://mogsdad.wordpress.com/2015/07/19/converting-from-uiapp-chart-service-to-html-service-google-visualization-api/)
/**
* Serves HTML of the application for HTTP GET requests.
* From gist.github.com/mogsdad/24518dff348ad14d3929
*
* @param {Object} e event parameter that can contain information
* about any URL parameters provided.
*/
function doGet(e) {
var template = HtmlService.createTemplateFromFile('Index');
@tariqhamid
tariqhamid / NSLookup.gs
Created June 21, 2016 18:12 — forked from mogsdad/NSLookup.gs
NSLookup - Google Sheets custom function to Perform a Network Service Lookup, using StatDNS API. From "Nslookup or dig in Google App Script" (http://stackoverflow.com/a/30610580/1677912).
/**
* Perform a Network Service Lookup, using StatDNS API.
*
* @param {"google.com"} dn A well-formed domain name to resolve.
* @return {String} Resolved IP address
* @customfunction
*/
function NSLookup(dn) {
// From gist.github.com/mogsdad/ece531531e0ef5dc355d
var url = "http://api.statdns.com/%FQDN%/a".replace("%FQDN%",dn);
@tariqhamid
tariqhamid / Apps Script Spreadsheet Utilities.md
Created June 21, 2016 18:14 — forked from mogsdad/Apps Script Spreadsheet Utilities.md

Google Apps Script Spreadsheet Utilities and Custom Functions#

These utilities are grouped into related files, for simpler copy & paste to your scripts.

ConvertA1.gs

A couple of helper functions to convert to & from A1 notation.

cellA1ToIndex( string cellA1, number index )

@tariqhamid
tariqhamid / Logger-Sidebar.html
Created June 21, 2016 18:46 — forked from mogsdad/Logger-Sidebar.html
Example showing use of Logger passthrough in client-side JavaScript. See https://mogsdad.wordpress.com/?p=193.
<script src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery.min.js"></script>
<script>
/**
* On document load, assign click handlers to button(s), add
* elements that should start hidden (avoids "flashing"), and
* start polling for document selections.
*/
$(function() {
// assign click handler(s)
$('#submit-button').click(function() {
@tariqhamid
tariqhamid / Apps Script Document Utilities.md
Created June 21, 2016 18:49 — forked from mogsdad/Apps Script Document Utilities.md

Google Apps Script Document Utilities

  • getAllLinks.js

  • getAllLinks(element) - returns array of all UrlLinks in Document

  • findAndReplaceLinks(searchPattern,replacement) - changes all matching links in Document

  • changeCase.js - Document add-in, provides case-change operations in the add-in Menu.

  • onOpen - installs "Change Case" menu

  • _changeCase - worker function to locate selected text and change text case. Case conversion is managed via callback to a function that accepts a string as a parameter and returns the converted string.

  • helper functions for five cases