Blog / Misc.

This section of the site is for "blog" type posts, short asides, and other miscellaneous bits of content that do not qualify as a project or tool.

Tips, tricks, and gotchas, for building a Google Data Studio Community Connector on Google Apps Script. Covers some common issues and recommended approaches.

How to get the UTF-8 Character Code (aka codepoint) for a given character in Google Sheets. Custom formula converts from UTF-16 decimal to UTF-8.

How to embed your Google Apps Script in an iframe when a user needs to authenticate it first before it can work. Solutions uses JSONP to inform parent page.

How to look at the basics of a Chrome crash report on Windows, using WinDbg to view the minidump file, and how to enable logging on startup.

Information on using TypeScript with Google Apps Script and Google Ads, both with and without Clasp. Also discusses how Apps Script treats hoisting.

A breakdown of different ways to embed static and dynamic content into iframes, and dynamically generate iframe embeds on both the client-side and server-side.

Some random notes on using the Power BI Embedded Javascript APIs, such as resetting slicer visuals.

Some tips on using Fabric.js as a dependency in your project, without requiring that other devs have Cairo installed in order to build.

Some random tips and tricks I've been collecting as I work on developing my first VSCode extension.

Getting a JSON source for the AMP-List carousel element working in AMP for Email Playground - resolving CORs header issues through HTACCESS.