Skip to content

Instantly share code, notes, and snippets.

function onEdit(e) {
var sheet = SpreadsheetApp.getActiveSheet();
var range = sheet.getActiveRange();
var row = range.getLastRow();
console.log('Last row is %s', row)
if(sheet.getName() === "BunqTransactions") {
Logger.log('BunqTransactions being updated')
sheet.getRange('D'+row).setValue('=D'+(row-1)+'+C'+row);
checkBunqDaily()
}
@Sth0nian
Sth0nian / Code.gs
Created May 24, 2022 22:34
uptime monitor
function init() {
if (ScriptApp.getScriptTriggers().length == 0) {
// Set up a monitor that triggers every 5 minutes
ScriptApp.newTrigger("websiteMonitor")
.timeBased().everyMinutes(5).create();
}
}
function websiteMonitor(){
var sites=SpreadsheetApp.getActiveSpreadsheet().getSheetByName("sites").getDataRange().getValues();
function doGet(e) {
Logger.log(e.parameter);
return HtmlService.createHtmlOutputFromFile('Page');
}
function findEmails (query, threshold){
let page = 0
foundemails = []
let threads
console.log('finding emails for query : ' + query + " older than "+threshold)
// This js could be dropped in place to change an <img> element with a specific ID to refresh every x number of seconds
function refreshCam(urlsource,target,timeout){
$("#"+target).attr("src",urlsource);
console.log("triggered!");
setTimeout(
function(){
refreshCam(urlsource,target,timeout);
},timeout*1000)
}
<br />
<script src=
"https://cdnjs.cloudflare.com/ajax/libs/fullPage.js/2.6.5/jquery.fullPage.min.js"
type="text/javascript">
</script><script type="text/javascript">
$("html").html('<div id="fullpage"><\/div>');
$("#fullpage").append('<nav id="navbar" style="position:fixed; top: 0; left: 0; z-index: 9999; width: 100%; height: 50px; background-color: rgba(51, 153, 51,0.8);"><div id="mobilemenu" style="color:white; padding-left:50px;"><h1>&#9776;<\/h1><\/div><ul id="myMenu"><li data-menuanchor="firstPage" class="active"><a class="mitem" href="#firstPage">Introduction<\/a><\/li><li data-menuanchor="secondPage"><a class="mitem" href="#secondPage">The Essentials<\/a><\/li><li data-menuanchor="thirdPage"><a class="mitem" href="#thirdPage">The Greenpeace vision<\/a><\/li><li data-menuanchor="fourthPage"><a class="mitem" href="#fourthPage">The Greenpeace structure<\/a><\/li><li data-menuanchor="fifthPage"><a class="mitem" href="#fifthPage">Action restricted<\/a><\/li><\/ul><\/nav>');
//add sections
### Keybase proof
I hereby claim:
* I am Sth0nian on github.
* I am stonian (https://keybase.io/stonian) on keybase.
* I have a public key whose fingerprint is 4987 8CA9 9525 919D 0DF6 AF76 CB88 8800 0159 9DAC
To claim this, I am signing this object:
body {
background-color: gray;
}
article {
width:720px;
margin:auto;
margin-top: -10px;
font-family:helvetica,
verdana, sans-serif;
padding-bottom:3em;
body {
font-family:arial;
font-size:25px;
}
table {
width:400px;
}
table th,td {
text-align:center;
border:1px solid;