mrlynn

function fyQ(date) {
  var d = new Date(date);
  var month = d.getMonth()+1;
  var year = d.getFullYear();
  // FY
  if (month > 1) {
    var year = year + 1
  }
  Logger.log("Year: " + year + " month: " + month)

mrlynn

/**
|* Insert this code into your Google Sheets Script Editor
|* From there, you can insert into a cell in the sheet =fetchCode("somevalue")
|* This will return the value fetched from the database and set a last date fetched.
|* Next time you want to fetch - it will compare the last date fetched. If it's more than a day
|* It will fetch again - otherwise, not.
**/

function fetchCode(code) {
    if (!code || code == "") {

mrlynn

exports = function(phoneNumber){
  const host = "lookups.twilio.com";
  const path = `/v1/PhoneNumbers/${phoneNumber}`;
  const lookupUrl = `https://lookups.twilio.com/v1/PhoneNumbers/${phoneNumber}`;
  const http = context.services.get("http");
  const { SID, Secret } = context.values.get("twilioCredentials");
  return http.get({
    "scheme": "https",
    host,
    path,

mrlynn

/****
 * This function runs automatically and adds a menu item to Google Sheets
 ****/
function onOpen() {
  var sheet = SpreadsheetApp.getActiveSpreadsheet();
  sheet.setActiveSheet(sheet.getSheetByName("Events"));
  var entries = [{
    name : "Export Events to MongoDB",
    functionName : "exportEventsToMongoDB"
  },{

mrlynn

/****
* Michael Lynn - http://blog.mlynn.org
* Stitching Sheets - Integrating Google Sheets with MongoDB Using MongoDB Stitch
****/

// Create an object which contains keys for each column in the spreadsheet
var columns = { // 0 indexed
  type: 2,
  date_start: 3,
  date_end: 4,

mrlynn

/****
 * Delete the events from the Calendar and remover the eventID Reference from the sheet - wipeout.
 ****/
function removeEventsFromMongoDB() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = spreadsheet.getSheetByName("Events");
  var headerRows = 1;  // Number of rows of header info (to skip)
  var range = sheet.getDataRange();
  var numRows = range.getNumRows();
  var data = range.getValues();

mrlynn

exports = async function(payload) {
   const mongodb = context.services.get("mongodb-atlas");
   const eventsdb = mongodb.db("events");
   const eventscoll = eventsdb.collection("events");
   const result= await eventscoll.insertOne(payload.query);
   var id = result.insertedId.toString();
   if(result) {
      return JSON.stringify(id,false,false);   
   }
   return { text: `Error saving` };

mrlynn

/****
 * Export the events from the sheet to a MongoDB Database via Stitch
 ****/
function exportEventsToMongoDB() {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var sheet = spreadsheet.getSheetByName("Events");
  var headerRows = 1;  // Number of rows of header info (to skip)
  var range = sheet.getDataRange(); // determine the range of populated data
  var numRows = range.getNumRows(); // get the number of rows in the range
  var data = range.getValues(); // get the actual data in an array data[row][column]

mrlynn

exports = async function(payload) {
  const mongodb = context.services.get("mongodb-atlas");
  const eventsdb = mongodb.db("events");
  const eventscoll = eventsdb.collection("events");
  const delresult = await eventscoll.deleteOne({name:payload.query.name, location: payload.query.location});
  return { text: `Deleted ${delresult.deletedCount} items` };
};

mrlynn

var countOuter = 0;
var countInner = 0;
var countSwap = 0;
array = [3,9,4,5,1,200,2,88]


dump(array);
var swapped;
do {
  countOuter++;