DavidKuennen

(function (context, trackingId, options) {
    const history = context.history;
    const doc = document;
    const nav = navigator || {};
    const storage = localStorage;
    const encode = encodeURIComponent;
    const pushState = history.pushState;
    const typeException = 'exception';
    const generateId = () => Math.random().toString(36);
    const getId = () => {

stravant

--X: 0-512
--Y: 0-384

-- Type bits: (-)(-)(-)(-) (spinner)(NC)(slider)(circle)

-- Circle: x,y,time,type,hitSound,extras

-- Slider: x,y,time,type,hitSound,sliderType|curvePoints,repeat,pixelLength,edgeHitsounds,edgeAdditions,extras
--         type = Linear Perfect Bezier Catmul

schlosser

// Installation & Setup
//   1. Create a spreadsheet.
//   2. Under Tools > Script Editor, paste this script
//   3. Under Resources > Libraries, add two library dependencies:
//      - OAuth2: 1B7FSrk5Zi6L1rSxxTDgDEUsPzlukDsi4KGuTMorsTQHhGBzBkMun4iDF
//      - FirebaseApp: 1hguuh4Zx72XVC1Zldm_vTtcUUKUA6iBUOoGnJUWLfqDWx5WlOJHqYkrt
//   4. Create a Firebase project and initialize the Realtime Database
//   5. Fill in your project details in FIREBASE_IO_URL and SERVICE_ACCOUNT below. 
//   6. Under Resources > Cloud Platform Project, add your Firebase project's project number from GCP. You
//      can find your project number in the GCP Cloud Console here: https://console.cloud.google.com/home/dashboard?project=_

stravant

local FooBar = {}
FooBar.__index = FooBar

function FooBar.new()
  local this = {
    _privateVariable = 137,
  }
  return setmetatable(this, FooBar)
end

tanaikech

Sample Scripts for Requesting to Web Apps by Various Languages

These are the sample scripts by the various languages for requesting to Web Apps created by Google Apps Script.

1. curl
2. Google Apps Script
3. Javascript
4. ajax

daolf

https://jennamolby.com/how-to-use-cookies-to-capture-url-parameters/

let YOUR_DOMAIN = "YOUR_DOMAIN.TLD" // ex: scrapingbee.com

function getParameterByName(name) {
	name = name.replace(/[\[]/, "\\[").replace(/[\]]/, "\\]");
	var regex = new RegExp("[\\?&]" + name + "=([^&#]*)"),
		results = regex.exec(location.search);
	return results === null ? "" : decodeURIComponent(results[1].replace(/\+/g, " "));
}

kurokobo

Simple Installer for Docker Compose on Container-Optimized OS on Google Computing Engine

The easiest way to make Docker Compose available on Container-Optimized OS on Google Compute Engine (GCE) on Google Cloud Platform (GCP).

This is minimal Bash script version of Community Tutorial.

How to use

Simply, download installer.sh, run it, and then reload bash by source ~/.bashrc or re-login.

tanaikech

Copying Protections for Spreadsheet using Google Apps Script

This is a sample script for copying the protections for Spreadsheet using Google Apps Script. When several protections of the sheet protection and the range protection are set to a Google Spreadsheet and the Spreadsheet is copied using the script and the manual copy with the browser, unfortunately, the protections of ranges are not copied. And also, the protections of sheets can be copied. But, the editor emails are not included. It seems that this is the current specification.

In this post, I would like to introduce a sample script for copying all protection conditions.

Sample script

Please add the following function to your script. And, please enable Sheets API at Advanced Google services.

tanaikech

Redeploying Web Apps without Changing URL of Web Apps for new IDE

At March 15, 2021, one endpoint is created for one deployment. Ref By this, when you redeploy "Web Apps", the endpoint is changed. Because the deployment ID is changed. It seems that this it the new specification. In this report, I would like to introduce the method for redeploying Web Apps without changing the URL of Web Apps for new IDE.

Deploy Web Apps

1. Open "New deployment" dialog with "Deploy" -> "New deployment".

2. Select "Web app" for "Select type".

al-codaio

// Create a loading bar in your Google Sheet using Google Apps Script
// Author: Al Chen ([email protected])
// Last Updated: April 13th, 2021
// Notes: Assumes you are using the V8 runtime (https://developers.google.com/apps-script/guides/v8-runtime)
// Example Google Sheet: https://docs.google.com/spreadsheets/d/1ngvYKEMunqCVufR10rlK42iENAERp-uyiPN_aiq-MKo/edit?usp=sharing

SOURCE_SHEET_ID = 'YOUR_GOOGLE_SHEETS_ID'
SOURCE_WORKSHEET_NAME = 'YOUR_WORKSHEET_NAME'

function loop() {