Phil Bainbridge phillypb

## Google Form - cleanse question titles.gs
/**
 * Main Function to get submitted Google Form data.
 *
 */

function getFormData(e) {


  // get all values from submitted Form
  var originalNamedValues = e.namedValues;

## Publish a Google Form to your domain.gs
/**
 * Code for: Publish a Google Form to your domain
 *
 * DEVELOPED BY THE GIFT OF SCRIPT: https://www.pbainbridge.co.uk/
 */


function setAnyoneInDomain() {

  // Form ID

## Get Google Form file upload links into a Google Doc.gs
function main(e) {


  // get all data from Google Form submission
  var formValues = e.namedValues;

  // get email address
  var emailAddress = formValues["Email address"][0];
  console.log("Email address is: " + emailAddress)

## Collate and organise a large Sheet of data.gs
/**
 * This script creates the menu item that can easily be selected to run the Function.
 */


function onOpen() {

  SpreadsheetApp.getUi()
    .createMenu('Admin')
    .addItem('Collate and Create', 'collateData')

## Create a dynamic Menu from content in a Google Sheet.gs
/**
 * Generate Menu items based on data in Google Sheet.
 *
 * Run the Function to display the popup message to the user after selecting one of the Menu items.
 */


// call this Function as soon as the Google Sheet has opened to generate our Menu items
dynamicMenu();

## Convert Sheet data into a JavaScript Object for easier handling.gs
/**
 * Get all Sheet data, call Function to Objectify, then loop through rows and log some items.
 */

function getPrettyData() {

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

  // get active sheet and log name

## Replace text in a Google Sheet with an image.gs
function replaceTextToImage() {


  // ******************** COMPLETE THESE ITEMS ********************
  var searchText = "";

  var imageURL = "";

  var rowHeight = 100;

## Automate the Google Education Plus upgrade for individuals.gs
/**
 * A number of Global Variables to speed up repetitive automation.
 */

var theSpreadsheet = SpreadsheetApp.getActiveSpreadsheet();

var timeZone = theSpreadsheet.getSpreadsheetTimeZone();

var logSheet = theSpreadsheet.getSheetByName("Log");

## Check date in future and a Wednesday.gs

function getFormData(e) {

  // get Spreadsheet TimeZone
  var timeZone = SpreadsheetApp.getActiveSpreadsheet().getSpreadsheetTimeZone();

  // get Form data
  var formValues = e.namedValues;

  // get specific values from Form ******************

## Exponential Backoff.gs
/**
 * Code to learn about Exponential Backoff.
 * Developed when experiencing 'Rate Limit' issue with updating a Calendar Event of Attendees.
 *
 * DEVELOPED BY THE GIFT OF SCRIPT: https://www.pbainbridge.co.uk/
 */


function mainFunction() {
	/**
	* Main Function to get submitted Google Form data.
	*
	*/

	function getFormData(e) {


	// get all values from submitted Form
	var originalNamedValues = e.namedValues;
	/**
	* Code for: Publish a Google Form to your domain
	*
	* DEVELOPED BY THE GIFT OF SCRIPT: https://www.pbainbridge.co.uk/
	*/


	function setAnyoneInDomain() {

	// Form ID
	function main(e) {


	// get all data from Google Form submission
	var formValues = e.namedValues;

	// get email address
	var emailAddress = formValues["Email address"][0];
	console.log("Email address is: " + emailAddress)
	/**
	* This script creates the menu item that can easily be selected to run the Function.
	*/


	function onOpen() {

	SpreadsheetApp.getUi()
	.createMenu('Admin')
	.addItem('Collate and Create', 'collateData')
	/**
	* Get all Sheet data, call Function to Objectify, then loop through rows and log some items.
	*/

	function getPrettyData() {

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

	// get active sheet and log name
	/**
	* A number of Global Variables to speed up repetitive automation.
	*/

	var theSpreadsheet = SpreadsheetApp.getActiveSpreadsheet();

	var timeZone = theSpreadsheet.getSpreadsheetTimeZone();

	var logSheet = theSpreadsheet.getSheetByName("Log");

	function getFormData(e) {

	// get Spreadsheet TimeZone
	var timeZone = SpreadsheetApp.getActiveSpreadsheet().getSpreadsheetTimeZone();

	// get Form data
	var formValues = e.namedValues;

	// get specific values from Form ******************
	/**
	* Code to learn about Exponential Backoff.
	* Developed when experiencing 'Rate Limit' issue with updating a Calendar Event of Attendees.
	*
	* DEVELOPED BY THE GIFT OF SCRIPT: https://www.pbainbridge.co.uk/
	*/


	function mainFunction() {