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
Changing the value in place based on a leading operator. Important Notes: * Since ‘+’ is a legal operator to start a formula, Sheets automatically converts it to ‘=’ * Using .splice() on e.value essentially forces it to be considered a String. Multiply it by read more