June 2015 - Desktop liberation

Running JavaScript directly from Excel makes ‘going Google’ easier

June 25, 2015 Comments Off

I’ve been dong a lot of writing over on Desktop Liberation looking at techniques to run Apps Script/JavaScript code directly from VBA, In this post I’m going to talk about how useful this can be if […]

Going GAS made it to the Best Google Books of All Time

BookAuthority collects and ranks the best books in the world, and it is a great honor to get this kind of recognition. Thank you for all your support! [...]
Going GAS Video

An accelerated video course over about 8 hours and 70 lessons taking you through JavaScript and Apps Script from start to finish. [...]
Video Course for Beginners

A video course over about 8 hours and 70 lessons taking you through the basics of Apps Script and JavaScript [...]
Going GAS Book

For those who prefer book and eBook formats, a 450+ page deep dive into Apps Script. Especially useful for those transitioning from another platform. [...]
Live Project

Create, Implement and test a AI Powered Google Workspace Add-Ons. add functionality from a collection of Google Cloud APIs such as Cloud Storage, CardService, Drive and others [...]

Scope and Namespaces
What can you learn here? Public versus Private Variable visibility External References If you read the section on procedure arguments you will have noticed the great capabilities …
Identify duplicates on Drive
Identify Duplicates on Google Drive The problem with Drive is that it’s really easy to have loads of files with the same name spread around …
Google Visualization
Create Google visualizations straight out of Excel. Here you can download a prebuilt application, googleCharts.xlsm that demonstrates how to integrate google Visualizations with Excel. The …
Repeatable add-on settings layouts and style
If you have a few add-ons, it’s good to make the Settings a consistent layout and behavior across them. It’s good for the add-on user, …
3 Favourite things in one article – redis, apps script and graphQl
Apps Script, Redis and GraphQL – together I’m a great fan of both Redis and GraphQL. You’ll find plenty of articles about them around on …

bruce mcpherson is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. Based on a work at http://www.mcpher.com. Permissions beyond the scope of this license may be available at code use guidelines