A place to expand your knowledge of Google Workspace, learn new Google Sheets formulas and tricks, and automate the boring stuff with Google Apps Script.
More?! Well, I also explore front-end development (JavaScript, HTML, CSS) and dive into other Google Cloud products like Firebase, and all the fancy Google APIs like Maps, Document AI, Chat, Admin Directory and so… so much more.
You can select from the 3 main categories below and see what I have been writing lately. In the sidebar, you can select a category item or use the search bar in the top right.
Want some more structured content? Head over to my courses pages for FREE and quality courses to upskill than grey mush 🧠! Need a handy solution for Google Sheets? Check out my products page or my list of Google Workspace Add ons.
Written by a real live human!
All Posts
Latest Posts
Get a Google Docs Body Text with Apps Script
Retrieving a Google Docs body text is quite easy with the help of Google Apps Script. Well, until it isn’t. Let me explain...
Colory – A small JavaScript Class for HEX to RGB, RGB to HEX conversion and Gradient Color List Building
This is a small JavaScript pseudo-class that I use to quickly convert HEX to RGB colour format and RGB back to HEX and also create an array of gradient colours between two colours. This guide is just a convenient place for me to store this reference for future use. I hope you can get some … Continue reading "Colory – A small JavaScript Class for HEX to RGB, RGB to HEX conversion and Gradient Color List Building"...
Clear and Set Conditional Formatting Rules to a Specific Range in Google Sheets with Apps Script
I’ve created a small (pseudo) class that more easily clears and creates conditional formatting rules in a Google Sheet tab with Google Apps Script. Why? Well in Google Apps Script, conditional formatting rules are all or nothing. Alf Specifically GIFfrom Alf GIFs You can only ever set, get or clear ALL rules in a specified … Continue reading "Clear and Set Conditional Formatting Rules to a Specific Range in Google Sheets with Apps Script"...
A custom-build HTML Time Input Element
Recently while working on a project, I found that the standard HTML Time Input field (see below) wasn’t sufficient for my needs. <input type="time" id="setTime" name="setTime" /> I needed users to be able to input 24hr time right down to the milliseconds. Something like this: Features Mobile Input will display the number pad Under the … Continue reading "A custom-build HTML Time Input Element"...
Setup Google Apps Script Word Completion in Sublime Text
When working on Google Apps Script projects locally with CLASP, it can be handy to have text completion for the Apps Script classes and methods. I’m currently shopping for a new IDE or text editor (the developer’s existential crisis) and have decided to pick up Sublime Text again after a 9-year hiatus after a mediocre … Continue reading "Setup Google Apps Script Word Completion in Sublime Text"...
Courses
A growing list of free and paid course:
Social
