Skip to content

Instantly share code, notes, and snippets.

View walkergv's full-sized avatar

Glenn Walker walkergv

View GitHub Profile
@walkergv
walkergv / pulautin.gs
Created December 17, 2019 16:26 — forked from k0sti/pulautin.gs
Yle Skenaariopeli - Korttipulautin
function onOpen() {
var ui = SpreadsheetApp.getUi();
ui.createMenu('Korttipulautin')
.addItem('Luo Ilmiökortit', 'createScenarioCards')
.addItem('Luo Linssikortit', 'createLensCards')
.addToUi();
}
function getNamedRange(name) {
var sheet = SpreadsheetApp.getActive();
@walkergv
walkergv / financial-data.csv
Created May 3, 2022 03:11
Sample Financial Data
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 7.
Segment,Country, Product , Discount Band ,Units Sold, Manufacturing Price , Sale Price , Gross Sales , Discounts , Sales , COGS , Profit ,Date,Month Number, Month Name ,Year
Government,Canada, Carretera , None ,1618.5, $3.00 , $20.00 ," $32,370.00 ", $- ," $32,370.00 "," $16,185.00 "," $16,185.00 ",2014-01-01,1, January ,2014
Government,Germany, Carretera , None ,1321, $3.00 , $20.00 ," $26,420.00 ", $- ," $26,420.00 "," $13,210.00 "," $13,210.00 ",2014-01-01,1, January ,2014
Midmarket,France, Carretera , None ,2178, $3.00 , $15.00 ," $32,670.00 ", $- ," $32,670.00 "," $21,780.00 "," $10,890.00 ",2014-06-01,6, June ,2014
Midmarket,Germany, Carretera , None ,888, $3.00 , $15.00 ," $13,320.00 ", $- ," $13,320.00 "," $8,880.00 "," $4,440.00 ",2014-06-01,6, June ,2014
Midmarket,Mexico, Carretera , None ,2470, $3.00 , $15.00 ," $37,050.00 ", $- ," $37,050.00 "," $24,700.00 "," $12,350.00 ",2014-06-01,6, June ,2014
Government,Germany, Carretera , None ,1513, $3.00 , $350.00 ," $529,550.00 ", $- ," $529
@walkergv
walkergv / elementor.gtm,.js
Created September 20, 2022 20:34
Data Layer Push for GTM Customer Event with Elementor
// Always endure you have given each form a Form ID in the Elementor backend or else action will not track.
jQuery( document ).ready(function( $ ){
jQuery( document ).on('submit_success', function(event) {
// for example, to submit a custom event to GTM DataLayer
//dataLayer.push({event:"GAEvent",eventCategory:"Form Submission", eventAction:event.target.id ,eventLabel:undefined});
});
});