allenyllee

// import_json_appsscript.js
// https://gist.github.com/allenyllee/c764c86ed722417948fc256b7a5077c4
//
// Changelog:
// (Oct. 16 2019) tag: allenyllee-20191016
// 1. Fixed google script error: urlfetchapp - service invoked too many times https://stackoverflow.com/questions/10598179/google-apps-script-urlfetchapp-service-invoked-too-many-times
// (Jul. 16 2018) tag: allenyllee-20180716
// 1. Fixed the issue "If you try to query /arrayA[k]/arrayB[n]/arrayC[m]/.../member, you will always get /arrayA[k]/arrayB[k]/arrayC[k]/.../member."
// (Nov. 30 2017) tag: allenyllee-20171130
// 1. Add the ability to query array elements by using xpath like "/array[n]/member" where "n" is array index

mesgarpour

/*
* Copyright 2017 Mohsen Mesgarpour
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
*     http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software

azadisaryev

/**
 * Convert Excel file to Sheets
 * @param {Blob} excelFile The Excel file blob data; Required
 * @param {String} filename File name on uploading drive; Required
 * @param {Array} arrParents Array of folder ids to put converted file in; Optional, will default to Drive root folder
 * @return {Spreadsheet} Converted Google Spreadsheet instance
 **/
function convertExcel2Sheets(excelFile, filename, arrParents) {
  
  var parents  = arrParents || []; // check if optional arrParents argument was provided, default to empty array if not

davidjgraph

/**
 * Explore plugin.
 */
Draw.loadPlugin(function(ui)
{
	// Adds resource for action
	mxResources.parse('exploreFromHere=Explore from here...');
	
	// Max number of edges per page
	var pageSize = 20;

paulgambill

/**
 * Retrieves all the rows in the active spreadsheet that contain data and logs the
 * values for each row.
 * For more information on using the Spreadsheet API, see
 * https://developers.google.com/apps-script/service_spreadsheet
 */
function readRows() {
  var sheet = SpreadsheetApp.getActiveSheet();
  var rows = sheet.getDataRange();
  var numRows = rows.getNumRows();

junaidk

###Online resources for learning Google Apps Script.

1. developers.google.com/apps-script/case-studies
2. ctrlq.org/dev/google-apps-script - by +Amit Agarwal
3. scoop.it/t/gas - by +Martin Hawksey
4. www.labnol.org/internet/google-scripts/28281/ - by +Amit Agarwal
5. scriptsexamples - by +James Ferreira & +Romain Vialard
6. shop.oreilly.com/product/0636920032557.do - by +James Ferreira
7. youtube.com/playlist?list=PL68F511F6E3C122EB - by +Eric Koleda and +Arun Nagarajan
8. appsscripttutorial - by +Waqar Ahmad

mogsdad

/**
 * 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);
}

tommcfarlin

<?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',

crstamps2

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

JuanCanham

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