rheajt

//My first attempt at creating a gulpfile.
//npm install --save-dev gulp gulp-connect gulp-sass gulp-babel babel-preset-react babel-preset-es2015
//run with 'gulp'
var gulp = require('gulp'),
    connect = require('gulp-connect'),
    babel = require('gulp-babel'),
    sass = require('gulp-sass');

gulp.task('default', ['babel', 'sass', 'connect', 'watch']);

rheajt

function Caesarize(shiftNum) {
  this.shiftNum = shiftNum; //the number to shift the alphabet
}

Caesarize.prototype.codify = function(sentence) {
  
  var sentenceArr = [];
  var shiftNum = this.shiftNum;
  
  sentence = sentence.toLowerCase();

rheajt

function onOpen() {
  SpreadsheetApp.getUi()
    .createAddonMenu()
    .addItem('KERNView', 'openKernView')
    .addToUi();
}

function onInstall() {
  onOpen();
}

rheajt

Turn your Google Sheet into a JSONP service

1. Copy the above code into the script editor
2. Replace 'SHEET_ID_TO_SERVE' with the key to the sheet you are trying to serve as JSON
3. Deploy as a web application
4. Copy the URL that is created
5. At the end of the URL add '?prefix=?'
6. Enjoy your new API!

I hope this is detailed enough description. If you are questions/comments/suggestions hit me up on twitter @rheajt

rheajt

/**
 * Combine cells into a single cell
 *
 * @param {text} the cells that need tobe combined
 * @return the single cell value
 * @customfunction
 */
function SINGLECOMBO(arrVals) {
  
  return arrVals.map(function(each) {return each.join(' - ');});

rheajt

function onOpen() {
  SpreadsheetApp.getUi().createAddonMenu().addItem('open picker', 'openPicker').addToUi();
}

function onInstall() {
  onOpen();
}

function getOAuthToken() {
  DriveApp.getRootFolder();

rheajt

function duplicate() {
  
  //number of duplicates to make
  var numOfDupes = 40;
  
  //create the spreadsheet object
  var ss = SpreadsheetApp.getActiveSpreadsheet();
  
  //we are going to loop the number of duplicates we want
  for(var i = 1; i <= numOfDupes; i++) {

rheajt

function doGet(e) {
  if(!e.parameters.sheetId) {
    return HtmlService.createTemplateFromFile('Start').evaluate().setSandboxMode(HtmlService.SandboxMode.IFRAME);
  } else {
    var html = HtmlService.createTemplateFromFile('Viewer');
    
    //set variable of sheet id to post in hidden input field for async request when page loads
    html.sheetName = SpreadsheetApp.openById(e.parameters.sheetId).getName();
    html.sheetId = e.parameters.sheetId;
    

rheajt

function doGet() {
  //open the Hidden.html page
  return HtmlService.createHtmlOutputFromFile('Hidden');
}

rheajt

function doGet() {
  //display the cryto.html page
  return HtmlService.createHtmlOutputFromFile('Crypto');
}