Random blog posts

Desktop Liberation and its related blog and G+ community aims to help you use cloud based APIS and services without being constrained by your desktop software. There’s a particular emphasis on Google APIs and JavaScript, but there’s also plenty of Microsoft and other stuff here too. All code here is unprotected and free to re-use

To support my site, and if you find the material useful, you can buy my Google Apps Script and VBA titles published by O’Reilly media.

Latest articles

  • The corona virus is with us, and naturally there’s much interest in data on its mortality, reach and spread, and of course much discussion on lockdowns, health capacity, social distancing and how they might affect [...]
  • Apps script now supports JavaScript ES6 Apps Script now supports the same modern JavaScript you can use when writing for the browser. Up until now you had to write in a dialect of JavaScript based [...]
  • var, const and let One of the key things that V8 has sorted out is the scope of variables. Using var to declare variables meant that anything declared within the scope of a function could [...]
  • This is a new section to collate various snippets related to GraphQL both from and back ends. For the purposes of these articles I’ll be concentrating on the integration of this collection of platforms with [...]
  • The data that comes back from GraphQL is not ideal for input to Elastic Search which is designed for full text searching, which means it loses context when searching arrays. Consider this response from some [...]
  • Sometime SQL just doesn’t cut it for the kind of searching that’s required nowadays, and you need to use something that’s designed for the purpose. Because of the GraphQL wrapper, it’s possible to change the [...]

The most geeky things

  • Using promises in JavaScript and other languages is the preferred way to orchestrate the completion of asynchronous activities. Here’s a (not perfect but fun) Promise implementation in VBA. Example includes getting data from Google Fusion tables. […]

  • A whole bunch of front end platform libraries that go together really well, but that are hard to grasp and get started with. Here’s a bunch of snippets to help show how all these things interact.. […]

  • The mathematics of color is a complex and interesting topic. Here you’ll find Google Apps Script, VBA and javascript examples of color manipulation including finding the closest match to a given color in a defined color scheme, and the infamous heatmap doughnut chart. There are lots of references to color on this site, and it seems to be a subject second only to jSon in popularity […]

  • Automating document ,creating Google Visualization and static tables of VBA projects, serialize instances of VBA classes and generating Google Apps Script skeleton of VBA projects. […]

The most popular topics

  • This collection of articles deal with various cloud platform APIS. The full content is below. It is part of a project that I will document at a later stage The next section is a series [...]
  • JSON and Excel using VBA classes that emulate JavaScript objects, parsing and stringifying JSON and dealing with data from external services. Includes a data driven REST-EXCEL library, and implementation of Google oAuth2 authentication […]

  • Geocoding, Mapping and creating data driven applications straight out of Excel get it now This article will cover 3 main topics. I wrote all this stuff a few years ago, and some of the services may [...]
  • What is d3.jsd3.js is a javaScript library that provides a ‘declarative framework’ for DOM manipulation and simplified access to SVG. d3 is the work of Mike Bostok and you should spend some time taking a look at the [...]
  • Migrating from VBA to Google Apps Script, or using them simultaneously can be hard to get started with. Although this material has been largely superceded by Going Gas, there’s stll some useful stuff here. […]

Categories

My Publications

Tag Cloud

Your browser doesn't support the HTML5 CANVAS tag.

My YouTube Channel

Google developers expert program

Full Site map

The content of the entire site is viualised here

All categories