walkergv

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

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

// 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});

	});
});