Apps Script
Obfuscate text with Apps Script
Sometimes you want to hide data in a sheet that’s being used for demo purposes.Here’s some options and library to help you do it. […]
snippets
Apps Script
Find an Apps Script library id in 10 seconds with scrviz
You want to include an Apps Script library, and you know it’s name, but not its id. A pain right? Here’s 3 easy steps to find it in https://scrviz.web.app Step 1 – find the library […]
General JavaScript techniques
TimeSimmer : An adjustable timer for apps that need to speed up or slow down time
TimeSimmer When creating simulations, and especially when testing or demoing apps that simulate events over time, you often need to speed up or slow down time. You may even need to slow it up or […]
General JavaScript techniques
Queuing asynchronous tasks with rate limit and concurrency constraints
Qottle If you are using an API you often need to queue tasks that are asynchronous and constrained by other factors such as rate limits of the API. Qottle is a general purpose queue manager […]
Vuejs
Vuejs and Vuetify – what does v-on mean
Many things in Vuetify and Vuejs are hard to come to grips with, but for me, none more so that the very odd property v-on and its relationship to v-slot:activator Two things that helped me see […]
API Specific
Using Google sheets via Bigquery from Apps Script
The Apps Script team released this post today about integrating BigQuery and sheets. So this means you can use SQL to access any sheets that you’ve linked to bigQuery. You can follow the instructions in […]
API Specific
Resumable uploads – writing large files to Drive with Apps Script
If you want to create a file of over 10mb in Drive, you can’t use either the DriveApp service or the Advanced Drive service. Even if you use the JSON API, the restriction of 10mb […]
API Specific
Migrating user and script properties
The old UserProperties and ScriptProperties services have been deprecated and replaced by the new PropertiesService. In the old service, a user property was available from all scripts to a particular user, and a script property […]
Apps Script & Java Script
Column numbers to characters
This is a very small Apps Script snippet to generate column addresses from column numbers that can be useful in things like Sheet Addons. For example 1 gives A, 27 – AA, 703 – AAA […]
Apps Script & Java Script
Copying canvas and svg images from your Add-on
Let’s say that you have an Add-on which creates something in Canvas (or SVG), and you want to now embed that in a Sheet or document. Here’s how. As an aside, the code samples here […]
Microsoft Office & VBA
Which VBA references you are using
VBA references Quite often you need to add some reference to be able to get some code to compile. This is because the code is referencing some external object that the Excel VBA does not […]
Snippets
Excel Comment shapes
What can you learn here? Interrupt comments Change shape characteristics Add timestamp Modifying the behavior of Cell Comment Processing Download now This article shows some techniques to interrupt the processing of cell comments in Excel […]
Recursion
Sorting Collections
Sorting collections is something you might need to do. In this example, we’ll use the cMyClass object we created in Get Started Snippets to demonstrate sorting a collection of objects and how to use recursion to sort the object’s […]
Integrating VBA and Javascript
Getting started with VBA
Although I’m not planning to go through a VBA tutorial (there are plenty of them out there far superior than anything I would do), it is clear that a many people do not actually know […]
Apps Script & Java Script
Deduce column headings from rest Query
In Rest to Excel library there are plenty of examples of populating sheets from rest queries. Usually you simply name the columns to match the data you want to extract and you are good to go. However, you […]
API Specific
Loading large JSON datasets into BigQuery with Apps Script
There are a number of ways to get data into BigQuery but one of the most convenient as far as Apps Script is concerned is to write it straight there from data generated during some […]
Apps Script & Java Script
Generating coupon codes with expiry dates
If you have some software or an add-on, and you want to find a way of giving a free trial that expires, one way is to create a token code that has all that built […]
Snippets
One Liners
What can you learn here? Using ramblings libraries Short code snippets Abbreviated explanations Complex stuff in a few lines of code get it now This section is going to cover how to do complex stuff in […]
Microsoft Office & VBA
jSon and Dynamic Forms
Now we know how about Hiding data in Excel Objects, Excel JSON conversion and Dynamic Forms let’s combine all that as an enhancement to the Roadmap Generation project. The objective is to embed traceability data in the generated roadmap shapes so […]
Google API
Apps Script & Java Script
Google Apps Script snippets
There are many Google Apps Script projects and snippets scattered around this site. I’m going to try to organize them in this page, but it will take a while. If you find something on the […]