draffensperger

Option Explicit

Private Type PersonQuery
    firstName As String
    lastName As String
    fullName As String
    firstNames As Range
    lastNames As Range
    fullNames As Range
    namesSwapped As Boolean

draffensperger

// Here's how the hints work:
// First 20 characters are used as single-character hints, and then it 
// switches to 2-character hints using the next characters. I wanted to make
// sure that the two character hints were easy to push.
//                  000000000011111111112
//                  012345678901234567890
Hints.characters = 'dkls;aie,cow.xpq/zvmrufj';

draffensperger

// Records a event with a given timestamp to a google sheet

const { google } = require("googleapis");

exports.recordEvent = async (req, res) => {
  if (!crypto.timingSafeEqual(Buffer.from(req.body.key),
                              Buffer.from(process.env.KEY)) {
    return;
  }  
  

draffensperger

We have some code that does a monkey-patch of a library function (maybe a bad design, but there may be other better examples of a similar pattern). The structure of the code looks about like this:

// This is code in a library
class Printer {
  value = 'b';

  print() {
    console.log(`value is ${this.value}`);
  }

draffensperger

workspace(name = "test_proto")

draffensperger

function onInstall(e) {
  onOpen();
}

function onOpen(e) {
  SpreadsheetApp.getUi().createAddonMenu()
      .addItem('Recalculate schedule', 'use')
      .addToUi();
}

draffensperger

def each_file()
  Dir.glob("**/*") do |file|    
    yield file unless File.directory? file
  end
end

def file_md5_name(file)
  ext = File.extname file
  digest = Digest::MD5.base64digest File.read file

draffensperger

require "rubygems"
require "bundler/setup"
require "stringex"

## -- Rsync Deploy config -- ##
# Be sure your public key is listed in your server's ~/.ssh/authorized_keys file
ssh_user       = "user@domain.com"
ssh_port       = "22"
document_root  = "~/website.com/"
rsync_delete   = false

draffensperger

function peopleBusy(people, startRow, startCol, endRow, endCol) {
  startRow = startRow || 2;
  startCol = startCol || 2;
  endRow = endRow || 40;
  endCol = endCol || 9;
  
  people = people.split(",");
  var ss = SpreadsheetApp.getActiveSpreadsheet(); 
  
  var n, i, j;

draffensperger

function getGCalData() { 
  var ss = SpreadsheetApp.getActiveSpreadsheet();

  var inSheet = ss.getSheetByName("GCalParams");
  var id = inSheet.getRange("B1").getValue();
  var startDate = inSheet.getRange("B2").getValue();
  var endDate = inSheet.getRange("B3").getValue();  

  var cal = CalendarApp.getCalendarById(id);
  var events = cal.getEvents(startDate, endDate);