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
Here I walk through how to copy a range that contains both values and formulas and keep both working. This includes showing issues along the way and why different approaches don’t work. Important notes: • .getFormulas() gets the entire range with only the formulas populated read more
How to move data from one spreadsheet to an entirely separate spreadsheet via Apps Script. Important Notes: * As with all on edit scripts, this script is not meant to be run manually but runs automatically from the trigger. * This must be done with read more