Skip to content

Instantly share code, notes, and snippets.

Miroslav schlos

  • Zagreb, Croatia
Block or report user

Report or block schlos

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
@schlos
schlos / detect-patterns.user.js
Created Oct 3, 2019 — forked from sonota88/detect-patterns.user.js
Greasemonkey script which detect patterns in html source.
View detect-patterns.user.js
// ==UserScript==
// @name detect-patterns
// @namespace anbt
// @include *
// ==/UserScript==
(function(){
if (window != unsafeWindow.top) { return; }
@schlos
schlos / contact-form.html
Created Apr 6, 2019 — forked from sharu725/contact-form.html
Jekyll Contact Form using Formspree
View contact-form.html
<!--
After implementing this contact form make sure
1. you have defined "email: youremail@email.com" in _config.yml file.
2. you verify your form on formspree.io.
-->
<form class="wj-contact" action="https://formspree.io/{{site.email}}" method="POST">
<input type="text" name="email" placeholder="Email Address">
<textarea type="text" name="content" rows="10" placeholder="Message"></textarea>
<input type="hidden" name="_next" value="<REDIRECTION LINK> ">
@schlos
schlos / Log.gs
Created Mar 17, 2019 — forked from andrewroberts/Log.gs
A simple wrapper for the BetterLog Google Apps Script Library - GAS Library MqTFuiXcPtS5rVUZ_jC9Z4tnfWGfgtIUb
View Log.gs
// 34567890123456789012345678901234567890123456789012345678901234567890123456789
// JSHint: 22 March 2015 08:56 GMT
// Unit Tests: 22 March 2015 08:50 GMT
/*
* Copyright (C) 2015-2017 Andrew Roberts (andrew@roberts.net)
*
* This program is free software: you can redistribute it and/or modify it under
* the terms of the GNU General Public License as published by the Free Software
@schlos
schlos / google-apps-script-github-burndown.js
Created Jan 16, 2019 — forked from gregorynicholas/google-apps-script-github-burndown.js
google apps script to create a github issues burndown chart
View google-apps-script-github-burndown.js
/**
* Heads to github fetches milestone info, and adds rows to spreadsheet
*/
function updateBugCounts() {
var resp = UrlFetchApp.fetch("https://api.github.com/repos/DramaFever/www/milestones?access_token=XXX");
var jsonStr = resp.getContentText();
var milestones = Utilities.jsonParse(jsonStr);
var dataSs = SpreadsheetApp.openById("YYY");
var sheet = dataSs.getSheetByName('Raw Data');
@schlos
schlos / question.md
Last active Jan 1, 2019 — forked from rubenrivera/question.md
Question - Answer from Web Applications [Show URL used to edit responses from a Google Form in a Google Spreadsheet by using a script](http://webapps.stackexchange.com/q/89551/88163)
View question.md

Revision 3 http://webapps.stackexchange.com/revisions/89551/3

Show URL used to edit responses from a Google Form in a Google Spreadsheet by using a script

I'm trying to make the edit URL for a Google Form automatically populate in the response Google Sheet that it's attached to. I've seen this already and want to use it, but I'm having issues trying to figure out where exactly to put the script.

I've tried putting it in the script editor in the Google Spreadsheet that I would like the URL to appear in, but I'm not sure where to go from there. In the script editor I've tried to test it as an add-on but that didn't end up working.

I have little experience with scripts and the script editor in Google Sheets. As a final note I am using one other add-on called AutoCrat in the same Google Spreadsheet.

@schlos
schlos / google-script-basecrm-api.js
Created Aug 26, 2018 — forked from superstrong/google-script-basecrm-api.js
Retrieve JSON data from the BaseCRM API and add it to a Google Sheet. This example retrieves all users. Stands on the shoulders of https://gist.github.com/varun-raj/5350595a730a62ca1954
View google-script-basecrm-api.js
function getBaseUsers() {
var options = {
"contentType" : "application/json",
"headers" : {
"Accept": "application/json",
"Authorization": "Bearer <TOKEN>"
}
}
var response = UrlFetchApp.fetch("https://api.getbase.com/v2/users", options);
var ss = SpreadsheetApp.getActiveSpreadsheet();
@schlos
schlos / google-script-asana-api.js
Created Aug 26, 2018 — forked from superstrong/google-script-asana-api.js
Retrieve JSON data from the Asana API and add it to a Google Sheet. This example retrieves all the users in a workspace. Stands on the shoulders of https://gist.github.com/varun-raj/5350595a730a62ca1954
View google-script-asana-api.js
function getAsanaUsers() {
var options = {
"headers" : {
"Authorization": "Bearer <TOKEN>"
}
}
var response = UrlFetchApp.fetch("https://app.asana.com/api/1.0/workspaces/<workspace-id>/users", options);
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheets = ss.getSheets();
@schlos
schlos / pullJSON.js
Created Aug 26, 2018 — forked from varun-raj/pullJSON.js
Google App Script To Fetch Data From JSON Webservice and Write them to google spreadsheet.
View pullJSON.js
function pullJSON() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheets = ss.getSheets();
var sheet = ss.getActiveSheet();
var url="http://example.com/feeds?type=json"; // Paste your JSON URL here
var response = UrlFetchApp.fetch(url); // get feed
var dataAll = JSON.parse(response.getContentText()); //
@schlos
schlos / gist:dfbafd17f7cdd68dfab1917da3bf9821
Created Aug 26, 2018 — forked from mhawksey/gist:1442370
Google Apps Script to read JSON and write to sheet
View gist:dfbafd17f7cdd68dfab1917da3bf9821
function getJSON(aUrl,sheetname) {
//var sheetname = "test";
//var aUrl = "http://pipes.yahoo.com/pipes/pipe.run?_id=286bbb1d8d30f65b54173b3b752fa4d9&_render=json";
var response = UrlFetchApp.fetch(aUrl); // get feed
var dataAll = JSON.parse(response.getContentText()); //
var data = dataAll.value.items;
for (i in data){
data[i].pubDate = new Date(data[i].pubDate);
data[i].start = data[i].pubDate;
}
@schlos
schlos / emailer.js
Created Aug 25, 2018 — forked from gnunicorn/emailer.js
Mass emailer with auto reply for forms
View emailer.js
/*
* Mass Emailer Google Spreadsheet and Forms Script.
*
* Changelog:
* 19. June 2013
* - also copy CC and BCC from draft email
* 27. May 2013
* - bugfix, kudos to @stefanhoth: the col is called "Email"
* - show the quota left for the day (thanks to @stefanhoth)
* 30. Apr. 2013
You can’t perform that action at this time.