labnol

// Part of this code up to END OF (c) is:
/*   
   Copyright 2011 Martin Hawksey

   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

labnol

/*   
   All code apart from getPlusones()
   Copyright 2011 Martin Hawksey 

   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

labnol

var DateTime = function() {
  var now = new Date();
  this.year = now.getFullYear();
  this.month = ('00' + now.getMonth()).slice(-2);
  var monthEndDate = new Date(this.year, this.month, 0);
  this.startDate = this.year + '-' + this.month + '-01';
  this.endDate = this.year + '-' + this.month + '-' + monthEndDate.getDate();
}

var Profile = function(profileName, tableId) {

labnol

/**
 * POST data from a Google Spreadsheet to a remote URL, via menu option Add-ons > Post values
 * See: http://www.google.com/google-d-s/scripts/guide.html for more info
 */

var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheets()[0];
var r = sheet.getRange("B5");

function onOpen() {

labnol

// INSTRUCTIONS:
// 1. Start a new form in Google docs
// 2. Go to Tools > Script editor from the spreadhseet
// 3. Paste in the below code
// 4. Go to Triggers > Current script's triggers
// 5. Add a new trigger
// 6. Select "onFormSubmit" then "On Form Submit" from the third select box. Click save.
// 7. Save the script and go back to your spreadsheet. You should see a "WHD Options" menu.
// 8. Click WHD Options > Ticket settings and enter the API key (from WHD's user setting screen) and the URL to your "Create Ticket" post. The script will automatically append "?apiKey=xxx" to the end of this URL.
// 9. Use the email settings in the WHD Options if you want to email users with their WHD ticket. 

labnol

// Do whatever you'd like with the script! Show it off, mod it up, post it places, or whatever. :)
// (If you do, I wouldn't mind a Twitter shoutout at @_slinehan when appropriate!)

$imageURL = "URL HERE";
$image = imagecreatefromjpeg($imageURL);

$width = imagesx($image);
$height = imagesy($image);

// First, let's resize the image to something manageable while maintaining aspect ratio.

labnol

// You create your bookmarklet by instantiating
// a new Bookmarklet function, then pass in the options like so.
// This example checks to see if the var is already defined, and makes
// sure not to overwrite it. This could happen if the user clicks on
// the bookmarklet more than once.

var MyBookmarklet = MyBookmarklet || new Bookmarklet({
  // debug: true, // use debug to bust the cache on your resources
  css: ['/my/style.css'],
  js: [],

labnol

Learning Google Apps Script

Find the best resources for learning Google Apps Script, the glue that connects all Google Workspace services including Gmail, Google Drive, Calendar, Google Sheets, Forms, Maps, and more.

A good place to learn more about Google Apps Script is the official documentation available at developers.google.com. Here are other Apps Script resources that will help you get up to speed.

1. Google Apps Script Code Samples by Amit Agarwal
2. Google Apps Script Development - Create Google Apps Script projects locally inside VS Code - video tutorial
3. Awesome Google Scripts by Amit Agarwal
4. Google Developer Experts - Follow Apps Scr

labnol

// 1. Go to https://twitter.com/following.
// 2. Keep scrolling to the bottom repeatedly until all your followers are loaded.
// 3. Run this in your console.
[].slice.call(document.querySelectorAll('.unfollow-text')).forEach(function(button) {
  button.click();
});