A bit of Google Apps Script that automates the process of generating personalized documents based on document templates using data stored in a spreadsheet.
Fill Google Doc Template Using Sheet Apps Script
Posted on 06/05/2025
Add Incremental Numbers Where Other Row is Not Blank
This is a simple bit of Google Sheets formula used to add a row of incremental number is row A where row B is not blank.
Posted on 25/02/2025
Lock Google Docs On Shared Drives
Here’s a simple bit of Google Apps Script for locking a document (effectively making the document read-only).
Posted on 28/01/2025
Replace Links With URL In Active Google Sheet
A simple bit of Google Apps Script that converts all links within an active Google Sheet into full URL links instead.
Posted on 28/01/2025
Set the APN on GPS Device Using a Hologram SIM Via SMS
A simple guide on how to set the APN on GPS device using a hologram SIM using a SMS message (via the Hologram Dashboard).
Posted on 17/12/2024
Get Last Row in A Column Using Google Apps Script
Another simple bit of code that’s worth writing down: how to get the last row in a specific column using Google Apps Script.
Posted on 08/12/2024
Count Cells That Contain A Word In Google Sheets
A simple bit of code that’s worth writing down for counting all cells in a column that contain a specific word/symbol.
Posted on 08/12/2024
Emulate Gameboy, GameCube & Windows on Android
Here’s my compilation of games successfully emulated on Android and a guide for how I accomplished each emulation on mobile and tablet.
Posted on 22/08/2024
Change Colour Of All Links On Active Google Sheet
A simple Google Apps Script that I came up with to change the colour of every link within the current active sheet all at once.
Posted on 29/07/2024
Keyboard Tricks
Fun and useful Windows key combinations for making symbols.
Posted on 12/07/2024
