Index

All Posts

Latest Posts

Update a Dropdown List Dynamically Across a Range in Google Sheets

Update a range of dropdown lists in a Google Sheet dynamically based on a corresponding dropdown choice

I don’t often do this*, but I recently got a question on my YouTube tutorial, Update dropdown list in Google Sheets dynamically based on previous dropdown choice: Data Validation, about whether or not this process can be applied to a column range. The short answer is yes. The long answer is that it is a … Continue reading "Update a range of dropdown lists in a Google Sheet dynamically based on a corresponding dropdown choice" ...
Get a unique list of objects in an array of objects in JavaScript

Get a Unique List of Objects in an Array of Object in JavaScript

Recently, I needed a way to ensure that my JavaScript array of objects does not contain any duplicates objects based on an ‘id’ key. While I do enjoy more common approaches to this solution with the use of a simple for loop it is always a bit of fun to see how folks have come … Continue reading "Get a Unique List of Objects in an Array of Object in JavaScript" ...
Google Apps Script GWAO File Picker Title

Create a Google Workspace Add-on file picker card with CardService that opens a Google Picker in an overlay window – Google Apps Script

Google Apps Script: Card Service, Google Workspace Add-on, Google Picker So you have this awesome idea for a Google Workspace Add-on (GWAO), but you need to be able to select Google Drive files and folders as a part of your process. Sure, you could just open up another tab and find the link and paste … Continue reading "Create a Google Workspace Add-on file picker card with CardService that opens a Google Picker in an overlay window – Google Apps Script" ...
Find and replace text with a link in Google Apps Script using DocumentApp

How to find and replace text in a Google Doc with a link or a list of links with Google Apps Script

So you are a citizen Google Apps Script developer and you’ve decided to make yourself a mail-merge-type project where you want to create new documents from a template. You have discovered the simplicity of the replaceText() method: var body = DocumentApp.getActiveDocument().getBody(); body.replaceText("{{TEMPLATE TEXT}}", "My New Text"); Now you want to take it to the next … Continue reading "How to find and replace text in a Google Doc with a link or a list of links with Google Apps Script" ...

Courses

A growing list of free and paid course:

Social

YoutubeICON
TwitterICON
LinkedinICON