pmakokluev / JSON_to_URLEncoded.js

Created August 23, 2023 11:16 — forked from lastguest/JSON_to_URLEncoded.js

Convert JavaScript object to x-www-form-urlencoded format

	function JSON_to_URLEncoded(element,key,list){
	var list = list \|\| [];
	if(typeof(element)=='object'){
	for (var idx in element)
	JSON_to_URLEncoded(element[idx],key?key+'['+idx+']':idx,list);
	} else {
	list.push(key+'='+encodeURIComponent(element));
	}
	return list.join('&');
	}

pmakokluev / GoogleSheetJson.md

Created September 13, 2022 23:30 — forked from ronaldsmartin/GoogleSheetJson.md

Google Spreadsheet JSON Queries

SheetAsJSON + Filtering

This is an extension of DJ Adams' excellent SheetAsJSON Google Apps Script, which provides a way to GET a published Google Spreadsheet as a JSON feed. This version allows generic filtering for terms, more specific control over which rows to parse, and correct MIME type for JSONP output.

Minimal Usage

The following parameters are required for the script to work.

https://script.google.com/macros/s/AKfycbzGvKKUIaqsMuCj7-A2YRhR-f7GZjl4kSxSN1YyLkS01_CfiyE/exec?
+ id=<spreadsheet key>
+ sheet=<sheet name on spreadsheet>

pmakokluev / _jsonPuller.md

Created September 13, 2022 23:20 — forked from jalcantarab/_jsonPuller.md

A Google apps script to pull json from a spreadsheet

JSON Puller - Google Apps Script

Transforms the data of a given Spreadsheet Sheet to JSON.

The frozen rows are taken as keys for the JSON.
The data taken for the values is only that after the frozen rows

Set up:

exportJSON(Spreadsheet) - transforms the data in the given sheet to JSON.

pmakokluev / exportjson.js

Created May 13, 2022 16:02 — forked from pamelafox/exportjson.js

Google Spreadsheet JSON ExportHow-to at http://blog.pamelafox.org/2013/06/exporting-google-spreadsheet-as-json.html

	// Includes functions for exporting active sheet or all sheets as JSON object (also Python object syntax compatible).
	// Tweak the makePrettyJSON_ function to customize what kind of JSON to export.

	var FORMAT_ONELINE = 'One-line';
	var FORMAT_MULTILINE = 'Multi-line';
	var FORMAT_PRETTY = 'Pretty';

	var LANGUAGE_JS = 'JavaScript';
	var LANGUAGE_PYTHON = 'Python';

pmakokluev / GoogleAppsScript2GitHub.gs

Created April 29, 2022 19:24 — forked from mhawksey/GoogleAppsScript2GitHub.gs

Example script that demonstrates how you can commit files to Github using Google Apps Script. If copying into a script project remembers to add a oAuth2 library https://github.com/googlesamples/apps-script-oauth2. More info in this post https://mashe.hawksey.info/?p=17293

	/*
	To use you need to create an application on Github at https://github.com/settings/developers

	The callback in this needs to be set to https://script.google.com/macros/d/{SCRIPT ID}/usercallback

	Where {SCRIPT ID} is the ID of the script that is using this library. You can find your script's ID in the Apps Script code editor by clicking on the menu item "File > Project properties".

	In this example code I've stored the apllicaitons clientId and clientSecret in the Script Properties:
	- git_clientId
	- git_clientSecret

pmakokluev / gist:b248b540c1bb417fab12168111218b10

Created April 25, 2022 07:30 — forked from mhawksey/gist:1170597

Google Apps Script to fill in a Document template with Spreadsheet data

	function onOpen() {
	var menuEntries = [ {name: "Create Diary Doc from Sheet", functionName: "createDocFromSheet"}];
	var ss = SpreadsheetApp.getActiveSpreadsheet();
	ss.addMenu("Fitness Diaries", menuEntries);
	}

	function createDocFromSheet(){
	var templateid = "1O4afl8SZmMxMFpAiN16VZIddJDaFdeRBbFyBtJvepwM"; // get template file id
	var FOLDER_NAME = "Fitness Diaries"; // folder name of where to put completed diaries
	// get the data from an individual user

pmakokluev / Async.gs

Created November 11, 2021 07:11 — forked from sdesalas/Async.gs

Asynchronous execution for Google App Scripts (gas)

	/*
	* Async.gs
	*
	* Manages asyncronous execution via time-based triggers.
	*
	* Note that execution normally takes 30-60s due to scheduling of the trigger.
	*
	* @see https://developers.google.com/apps-script/reference/script/clock-trigger-builder.html
	*/

pmakokluev / barcode-128-svg.js

Created May 26, 2021 15:35 — forked from jcormont/barcode-128-svg.js

Simple Code-128 (128B) barcode SVG generator, in vanilla JS

	var Barcode128Svg = (function () {
	function Barcode128Svg(input) {
	this.input = input;
	this.factor = 2;
	this.height = 75;
	}

	var lookup = {}, data = "212222222122222221121223121322131222122213122312132212221213221312231212112232122132122231113222123122123221223211221132221231213212223112312131311222321122321221312212322112322211212123212321232121111323131123131321112313132113132311211313231113231311112133112331132131113123113321133121313121211331231131213113213311213131311123311321331121312113312311332111314111221411431111111224111422121124121421141122141221112214112412122114122411142112142211241211221114413111241112134111111242121142121241114212124112124211411212421112421211212141214121412121111143111341131141114113114311411113411311113141114131311141411131".split(/(\d{6})/).filter(function (s) { return !!s });
	for (var i = 32; i < 127; i++)
	lookup[String.fromCharCode(i)] = [i - 32, data[i - 32]];