Home: Google Workspace Development, Google Sheets, Front-end, Google Cloud

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.

Google Apps Script Homepage Button

Google Apps Script

 

 

Google Sheets Homepage Button

Google Sheets

 

 

Google Sheets Homepage Button

Other Topics

 

 

All Posts

Latest Posts

Feature image for Display the financial year of a date in Google Sheets

A Better Financial Year Formula In Google Sheets

The most common financial year formula for Google Sheets looks a little like this: =IF(MONTH(A3) < 7, YEAR(A3) - 1, YEAR(A3)) Where: =IF(MONTH(date) < financial_year_starting_month, YEAR(date) - 1, YEAR(date)) In Australia, our financial year starts on the 1 July. So that’s what I’ve used in the example...

Read More
Prevent consecutive clicks of a Google Sheet Image Button with Lock Service

Prevent consecutive clicks of Google Sheets Image Buttons in with Lock Service and Google Apps Script

Ever seen an overzealous user madly clicking on an image button in Google Sheets to run an automation script? It’s maddening, frustrating and most importantly, may cause errors in your beautifully crafted code. How Iplaysmash GIFfrom How Iplaysmash GIFs In this short tutorial, we explore how to use Google Apps Script’s Lock Service to prevent … Continue reading "Prevent consecutive clicks of Google Sheets Image Buttons in with Lock Service and Google Apps Script"...

Read More
FILTER dates and times in Google Sheets Thumbnail

Google Sheets FILTER function: Dates and Times

If you have landed on this page you may have discovered that dates and times don’t always work as you might expect with the Google Sheets FILTER  function. In this tutorial, we are going to cover how to use FILTER on dates, times and date and time stamps (DTS). You can follow through the tutorial … Continue reading "Google Sheets FILTER function: Dates and Times"...

Read More
Hacker with lock in front of face CSRF token apps script

Preventing Cross-Site Request Forgery (CSRF) in Google Apps Script Dialogs and Sidebars

Cross-Site Request Forgery (CSRF) is a web security vulnerability that allows a nefarious entity to take actions on a website that are unintended by the user. Typically, this is done by tricking the user into using another website resembling the intended site and then submitting a form or clicking a button. The dodgy site then … Continue reading "Preventing Cross-Site Request Forgery (CSRF) in Google Apps Script Dialogs and Sidebars"...

Read More

Courses

A growing list of free and paid course:

Social

YoutubeICON
TwitterICON
LinkedinICON