phillypb

/**
 * Function to replace <<keyword>> tag in Google Doc with relevant image.
 * 
 * @OnlyCurrentDoc
 * 
 * DEVELOPED BY THE GIFT OF SCRIPT: https://www.pbainbridge.co.uk/
 */


function replaceTextToImage() {

phillypb

/**
 * Developed by The Gift of Script: https://www.pbainbridge.co.uk/
 */


function getFileInfo() {


  // ID of the folder to scan for files
  var folderId = "ENTER YOUR FOLDER ID HERE";

phillypb

function checkTriggers() {

  // get active spreadsheet
  var ss = SpreadsheetApp.getActiveSpreadsheet();

  // get all existing Triggers
  var triggers = ScriptApp.getUserTriggers(ss);

phillypb

/**
 * Lock Service - lock code to prevent overwriting data (concurrency).
 * https://developers.google.com/apps-script/reference/lock
 */


function onFormSubmit(e) {

  // get lock that prevents any user from concurrently running a section of code.
  var lock = LockService.getScriptLock();

phillypb

/**
 * Script to take a Microsoft Excel file.
 * Convert to a Google Sheet, remove unnecessary data/columns/rows.
 * Add some data/columns/rows.
 * Insert formula to concatenate email addresses.
 */



// enter the ID of the Excel file below

phillypb

/** 
 * Function to check if date in spreadsheet is less than todays date.
 * If so then autofill formulas down a row.
 * Run via daily Trigger.
 * 
 * @OnlyCurrentDoc 
*/

function autofill() {

phillypb

function getFormData(e) {

  // get all Form responses
  var formValues = e.namedValues;

  // get response to specific question
  var pizzaTopping = formValues["Favourite Pizza Topping"][0];
  console.log("pizzaTopping is: " + pizzaTopping);

phillypb

/*
Function to sort through an array of duplicates, to then create a new array of
unique values.
*/

function sortArray() {

  // array to sort
  var messyArray = ['A', 'B', 'A', 'C', 'B', 'B', 'B'];

phillypb

/*
Some Global Variables to make it easier to keep a track of changing column
positions, etc.
*/

// 'Folder Name' column number
var folderNameCol = 1;

// 'Folder Link' column number
var folderLinkCol = 2;

phillypb

function saveToProperties() {

  // save to User Properties in one go
  var userProperties = PropertiesService.getUserProperties();
  var newProperties = {
    sourceFolderId: '123',
    destinationFolderId: '456',
  };
  userProperties.setProperties(newProperties);