Spencer Speaks

Purple Thoughts

  • Home
  • Contact Me

Protect the Same Ranges of Every Tab

September 9, 2021 Spencer In Google Sheets, Scripting 0 comments

How to protect the same asynchronous ranges on every tab on a Sheet. Important notes: * The ranges in an array of A1 notation Strings of the ranges. Make sure the quotation marks are around them * Don’t mix up the variables for each FOR() read more

Fill Google Doc with Sheets data

August 27, 2021 Spencer In Google Sheets, Scripting 0 comments

Using body.replaceText() to replace specific areas of a Google Doc with data from a Sheet. Three parts: 1. Replace data directly on a Doc 2. Make a copy of the Doc (template) then replace data on the copy 3. Loop through several rows of Sheet read more

Add Form Response to Form

August 3, 2021 Spencer In Google Sheets, Scripting 0 comments

How to add a Form response to the Form as a checkbox item. Important notes: * This can be done from the Form script editor itself, rather than the Sheet * The trigger must be installed * The steps are important: Get the correct item, read more

Move Rows With Different Tab Names – Dropdown

July 29, 2021 Spencer In Google Sheets, Scripting 0 comments

How to move rows between tabs where the dropdown options and the tab names don’t match. Important notes: * The indices of the 2 arrays must match, else the data will transfer improperly. * Since this is an onEdit script it is not meant to read more

Use Checkboxes as Radio Buttons with the Properties Service

July 14, 2021 Spencer In Google Sheets, Scripting 0 comments

A follow-up to Use Checkboxes as Radio Buttons with FOR() Loop https://www.youtube.com/watch?v=FLyWXdA4FuA Use Checkboxes as Radio Buttons using the Properties Service. Important notes: DO NOT run the script manually, it will fail. Make sure the Property gets properly set on the first pass. Sheet (to read more

Use Checkboxes as Radio Buttons with a FOR() loop

July 7, 2021 Spencer In Google Sheets, Scripting 0 comments

Using a FOR() loop to make checkboxes behave as radio buttons. Important notes: DO NOT run the script manually, it will fail. Make sure the array indexes and the Sheet rows match with some math. Sheet (to copy – go to File, Make a copy) read more

Open Sheet to Last Used Tab / Range

June 29, 2021 Spencer In Google Sheets, Scripting 0 comments

  Using onEdit, onOpen, and the Properties Service to open a Sheet to the last used tab and/or range Important notes: * Remember not to manually run the onEdit or onOpen functions – they will run automatically whenever the Sheet is edited or opened * read more

INTRO: Using onChange to Trigger Specific Events

June 8, 2021 Spencer In Google Sheets, Scripting 0 comments

This is an introduction to the concept of using onChange to trigger specific events as opposed to onEdit. The challenge: onEdit() doesn’t fire when the change is the result of a formula, including IMPORTRANGE(), GOOGLEFINANCE(), etc. and onChange() doesn’t include the source, range, or value read more

Google App Script Properties and Cache Services

June 2, 2021 Spencer In Google Sheets, Scripting 0 comments

A different kind of video showing the Properties and Cache Services available for Google Apps Script. Important Notes: * The Properties and Cache Services are designed to hold data for use beyond a single run of a script. * The Legacy IDE had an option read more

Create and Populate a Sheet from Template onEdit

May 25, 2021 Spencer In Google Sheets, Scripting 0 comments

Using an onEdit trigger to create a sheet from a template and fill in relevant information. Important notes: * Do not run the script manually. Like all onEdit() scripts, the ‘e’ parameter passes necessary information to the script and only exists when run automatically from read more

← Previous 1 2 3 … 5 Next →

Copyright © 2023 Spencer Speaks. All rights reserved. Designed by Free WP Themes