Phil Bainbridge phillypb

## Correct date formats in a Google Sheet.gs
/**
 * Developed by The Gift of Script: https://www.pbainbridge.co.uk/
 */


function onOpen() {

  SpreadsheetApp.getUi()
    .createMenu('Admin')
    .addItem('Fix Dates', 'fixDates') // label for menu item, name of function to run.

## Probation Tracker Tool.gs
/**
 * Function to create menu items for Trigger
 */


function onOpen() {

  SpreadsheetApp.getUi()
    .createMenu('Admin')
    .addItem('Create Trigger', 'createTrigger') // label for menu item, name of function to run.

## Replace text in a Google Doc with an image.gs
/**
 * 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() {

## Drive API - get file information.gs
/**
 * 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";

## Check for existing Form Submit Triggers.gs

function checkTriggers() {

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

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


## Control Form submissions with Script Lock.gs
/**
 * 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();

## Format and tidy a Google Sheet report.gs
/**
 * 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

## Autofill Google Sheet Formula each day.gs
/**
 * 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() {

## Google Form Checkbox responses.gs
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);


## Sort through an array of duplicates with Sets.gs
/*
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'];
	/**
	* Developed by The Gift of Script: https://www.pbainbridge.co.uk/
	*/


	function onOpen() {

	SpreadsheetApp.getUi()
	.createMenu('Admin')
	.addItem('Fix Dates', 'fixDates') // label for menu item, name of function to run.
	/**
	* Function to create menu items for Trigger
	*/


	function onOpen() {

	SpreadsheetApp.getUi()
	.createMenu('Admin')
	.addItem('Create Trigger', 'createTrigger') // label for menu item, name of function to run.
	/**
	* 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";

	function checkTriggers() {

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

	// get all existing Triggers
	var triggers = ScriptApp.getUserTriggers(ss);
	/**
	* 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();
	/**
	* 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
	/**
	* 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() {
	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);
	/*
	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'];