Apps Script
Color scales, custom schemes and proxies with Apps Script
How to add Google Material Colors and your own custom schemes to chroma […]
fiddler
Apps Script
Content oriented color mixing with Apps Script
Apps Script library to derive colors and color mixtures based on text to help contextualize sheets content. […]
Apps Script
Calculate contrasting font colors for Sheets.
If you are playing around with Sheet colors with Apps Script, you sometimes find yourself with font colors that don’t go well with the background colors you’ve chosen. However, we can use Yiq values to […]
Apps Script
SuperFetch Plugins: Apps Script streaming with Tank and Drive
Tank and Drv are SuperFetch plugins to emulate streaming and use the Drive REST API with Apps Script. SuperFetch is a proxy for UrlFetchApp with additional features – see SuperFetch – a proxy enhancement to […]
API Specific
SuperFetch – Twitter plugin for Apps Script – Get Follows, Mutes and blocks
Twt is a SuperFetch plugin to easily access to the Twitter v2 API. SuperFetch is a proxy for UrlFetchApp with additional features – see SuperFetch – a proxy enhancement to Apps Script UrlFetch for how […]
Add-ons
Add-on for decrypting columns in Google Sheets
In Merging sheets from multiple sources and encrypting selected columns I published some code for selectively copying columns from multiple input spreadsheets/sheets to create summary sheets, and optionally encrypting columns. The idea was to distribute the […]
Apps Script
Merging sheets from multiple sources and encrypting selected columns
Sometimes you have a forest of spreadsheets each with multiple sheets, but you only want to share a selection of those sheets. You could cut and paste, but that’s error prone and difficult to repeat. […]
Apps Script
Fiddler now supports joins to merge matching columns from multiple sheets
You may have come across my post on SQL for Apps Script it’s here where I shared a library for using SQL syntax in Apps Script to do things like joining tables. For some cases, this […]
Apps Script
A fourth way to preserve and create formulas with Fiddler for Sheets, plus some more new methods
This is (probably) the last in a series of posts describing how Fiddler for Sheets can be used to help with formula manipulation and creation, as well as column insertion and deletion without caring too […]
Apps Script & Java Script
A third way to preserve formulas with fiddler, plus 2 new methods
In 2 ways to create and preserve formulas with fiddler for Google Apps Script I gave some examples of how to preserve formulas if you are using fiddler for Sheets. Fiddler does have a number of […]
Apps Script
2 ways to create and preserve formulas with fiddler for Google Apps Script
I’ve had a few queries from fiddler users about how to deal with formulas. Fiddler is primarly for abstracting spreadsheet values so they can be manipulated and updated without worrying too much about the physical […]
Add-ons
Handly helper for fiddler
If you use some of my libraries, you may have come across the Fiddler class, which abstracts sheet data and provides a more functional way to manage data from multiple sheets in a Google Spreadsheet. […]
Add-ons
Optimize updates to Google Sheets with fiddler fingerprints
If you use some of my libraries, you may have come across the Fiddler class, which abstracts sheet data and provides a more functional way to manage data from multiple sheets in a Google Spreadsheet. […]
Add-ons
How to use Vue.js, Vuex and Vuetify to create Google Apps Script Add-ons
Create beautiful Apps Script add-ons with Vuetify and Vue.js The idea of ‘reactive programming’ has been around for many years, but frameworks such as React, Vue and so on have moved it into the mainstream. […]