Sometimes it can be handy to find the day of the year* that a particular date falls on in JavaScript.
Let’s say you want to get the day of the year for Pie Day (14 Mar 2024). Check out the code:
*This tutorial is for the Gregorian Calendar.
Blog Feed
Google Workspace Custom Dialog: ACCESS DENIED and similar errors
This guide is designed to help you quickly solve issues related to running scripts from custom-built dialogue boxes in Google Sheets, Docs, Forms and Slides, most notably, the “ACCESS DENIED” error and other related errors.
This guide is for Google Workspace users and not necessarily for Google Workspace Developers. If you would like to learn how to handle for these issues programmatically, check out the link here (Handling Dialog and Sidebar Access Issues in Google Workspace Apps).
Use this guide as a quick reference for troubleshooting your own problem or share it with a team member if they need assistance.
Continue reading “Google Workspace Custom Dialog: ACCESS DENIED and similar errors”
GWAOw! 6 – Sign PDF with Jotform Sign
In this episode of GWAOw!!! we look at Sign PDF with Jotform Sign.
About Sign PDF with Jotform Sign
Sign PDF with Jotform Sign is a Google Workspace Add On (GWAO) that allows you to collect e-signatures for any PDFs stored in your Google Drive.
This is such a useful tool that I have moved to Sign PDF with Jotform Sign for e-signatures of my client service agreements.
The add-on has some great tools that allow you to create and edit the input fields for your document before sending it to signatories.
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.
Continue reading “A Better Financial Year Formula In Google Sheets”
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.
In this short tutorial, we explore how to use Google Apps Script’s Lock Service to prevent users from executing your code from your image button while the original instance of the code is still running.
Grab a copy of the starter sheet below to play along.
To the Starter Sheet