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
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
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
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
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
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
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
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
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
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