phillypb

/*
This overall script is designed to bulk create Google Sheets from data within a Google Sheet.
*/

function getSpreadsheetData() {

  // Log starting of the script
  logEvent('Script has started');

  // get current spreadsheet

Max-Makhrov

function test_parse() {
  var file = SpreadsheetApp.getActive();
  var sheet = file.getSheetByName('Sheet1');          // change
  var sets = {
    rangeParse: sheet.getRange('L2:L16429'),          // change
    rangeResult: sheet.getRange("M2"),                // change
    func_parse: parseOkkoFilmToGetHorizontalPoster_   // change / create your function
  };
  parseUrls_(sets);
}

Max-Makhrov

function readTimer() {
  
  // [ 1 ]. Get report 
  var tags = ['onMinute_admin', 'onMinute_worker', 'onMinute_importer', 'onMinute_sizif1', 'onMinute_sizif2'];
  var report = getTimerReps_(tags);
  console.log(report); 
  // => gives 2D Array with a report about executions.
  //    So U can write it on Spreadsheet.

  // [ 2 ]. Gat all data from logs

thealchen

// Create a loading bar in your Google Sheet using Google Apps Script
// Author: Al Chen (al@coda.io)
// Last Updated: April 13th, 2021
// Notes: Assumes you are using the V8 runtime (https://developers.google.com/apps-script/guides/v8-runtime)
// Example Google Sheet: https://docs.google.com/spreadsheets/d/1ngvYKEMunqCVufR10rlK42iENAERp-uyiPN_aiq-MKo/edit?usp=sharing

SOURCE_SHEET_ID = 'YOUR_GOOGLE_SHEETS_ID'
SOURCE_WORKSHEET_NAME = 'YOUR_WORKSHEET_NAME'

function loop() {

phillypb

/*
This overall script is designed to bulk create Google Folders from data within a Google Sheet
and add relevant permissions (if applicable).
*/

function getSpreadsheetData() {
  
  // Log starting of the script
  logEvent('Script has started');
  

phillypb

/*
Global variables to be accessed in other parts of the scripts.
*/
// get spreadsheet
var ss = SpreadsheetApp.getActiveSpreadsheet();

// get Welcome sheet
var welcomeSheet = ss.getSheetByName('Welcome');

// get values from Welcome sheet

mhawksey

// Handling inline images and attachments so they can be included in the merge
// Based on https://stackoverflow.com/a/65813881/1027723
// Get all attachments and inline image attachments
const msg = draft.getMessage();
const allInlineImages = msg.getAttachments({includeInlineImages: true, includeAttachments: false});
const attachments = msg.getAttachments({includeInlineImages: false});
const htmlBody = msg.getBody(); 
 
// Create an inline image object with the image name as key 
// (can't rely on image index as array built based on insert order)

phillypb

/*
create HTML modal dialogue box that won't suspend script.
https://developers.google.com/apps-script/reference/base/ui#showmodaldialoguserinterface,-title
*/

function showHTMLPopup() {

  var htmlOutput = HtmlService
    .createHtmlOutput('<p>Congratulations this was a success.</p>')
    .setWidth(320)

HackettYu

obhular

/**
* Check When Array was last Edited
*
* @param array Select the Array you want to check to see when it is updated i.e "A5:B5"
* @param timestampCell Select the Cell you want to put the timestamp for when array updated i.e "A1"
* @customfunction
*/

function LASTEDIT(array,timestampCell) {