AppsScriptPulse

Structure and simplify your Google Apps Script (with) V8

Apps Script now supports the V8 runtime. Time for an update to the story “Structure and simplify your Google Apps Script Apps script”. The V8 runtime brings modern ECMAScript syntax to Apps Script. So we can now use arrow functions and destructuring assignments. No more hoisting with let and const and my personal favorite, template literals.

In this story Jasper Duizendstra shows the added value of the changes made in the constructor pattern using the factory functions. It also shows how to implement chaining and a builder pattern in Apps Script.

Source: Structure and simplify your Google Apps Script (with) V8

Reliable, Secure & Scalable use of Google Apps Script | Google Developers Experts

Most conversations around solutions or automations created using Apps Script eventually get to a point where being able to address concerns around its reliability, security and scalability becomes a challenge — more so if compared to having similar applications being built on other platforms (say: AWS, GCP, Firebase etc.).

In this post, we’ll see how to navigate our way through said constructs by addressing parts of these problems and also explore ways in which we can bake some solutions right from the get-go!

In this post Sourabh Choraria provides some very useful answers for common questions organisations have when using Google Apps Script as part of their infrastructure. Points covered in this post include: managing concurrent executions; being able to securely store, access & manage API keys, tokens; and considerations around quotas.

Source: Reliable, Secure & Scalable use of Apps Script | Google Developers Experts

AppSheet purchased by Google Cloud – News – Google Groups

Google Cloud has acquired AppSheet. Do I care? At first I thought, “Not really, it’s just interesting news.”

I guess that I do care in the sense that I want to be valued as a programmer, and no-code development feels like programmers are being thrown away in favor of something else. The driving force behind this is development costs. Even if an independent programmer only charged $5 dollars an hour, in two hours the customer would have paid $10 dollars, which is twice as much money as the $5 a month AppSheet plan.

It was recently announced that Google has acquired AppSheet a low-code platform for business users that lets you build applications that can integrate into a variety of sources including Google Sheets. This has resulted in an interesting thread on the Google Apps Script Community Google Group linked to from the source link at the end of this post, in particular, impact on Apps Script developers. On the one hand you can argue that products like AppSheet, with there low/no code environments remove the need for developers. However, the general consensus on the thread is rather than removing developer opportunities it may in fact create them with opportunities to extend the basic functionality of AppSheets. This comment from Alan Wells in particular caught my eye:

What AppsSheet does, is increase the number of apps and code being created, as opposed to lots of business creating no apps at all.  It’s kind of like, you need a lot more mechanics if everyone can afford a car.  If only the rich can afford a car, then there aren’t going to be many car mechanic jobs.  So, I think that AppSheet is filling a need, which increases the number of apps.  Some of those apps will crash, and they’ll need the equivalent of an auto body technician to repair the damage.  This is part of the evolution of the computing industry.

You can join in on this discuss using the following link:

Source: AppSheet purchased by Google Cloud – News – Google Groups

I summarized my own practices on what Google Apps Script is strong and when to use it

Yuki Tanabe shares some strengths and weaknesses of Google Apps Script as well as criteria for choosing Google Apps Script for your coding project

Source: I summarized my own practices on what Google Apps Script is strong and when to use it

2019 – a decade in Apps Script | Desktop Liberation

A brief history of apps script capabilities – There’s been much coming and going over the past 10 years. Here’s a non-exhaustive list of some of the winners, and losers.

Source: 2019 – a decade in Apps Script | Desktop Liberation

Why you shouldn’t use Google Sheets as a database – Eric Koleda – Medium

At this year’s Google Cloud Next I co-presented a session entitled “How to grow a spreadsheet into an application,” where the thesis was that it’s OK to start with a spreadsheet and layer on additional technologies as you gain adoption and your requirements change. However that doesn’t mean that Sheets is always a great choice for storing your application’s data, and in this post I’ll explore some of the signals that you should be looking into other database options. Sheets are for people!

Source: Why you shouldn’t use Google Sheets as a database – Eric Koleda – Medium

Why Google Apps Script Is a Great First Programming Language to Learn

Google Apps Script is the perfect programming language to learn first, even if you’ve never heard of it before! Here are 7 reasons why.

Source: Why Google Apps Script Is a Great First Programming Language to Learn

2018 – yet another year in and out of Google Apps Script | Desktop Liberation

What’s been happening in Apps Script … The modernization of the Sheets API and the Calendar API, the release of the Slides API and most recently the Docs API have all opened up many new capabilities for Apps Script regular and advanced services. The Docs API does not yet have an advanced service so you need to go to the API directly, but as with Sheets and Slides, over time you’ll probably see one arriving along with some of the more advanced features being integrated into the regular Apps Script service. Let’s look at a few of the new goodies (and not-so goodies).

Source: 2018 – yet another year in and out of Google Apps Script | Desktop Liberation

What’s behind the numbers in the G Suite Marketplace?

Awesome Table has recently joined the very exclusive club of apps that have reached the 10M user milestone on the G Suite Marketplace, like Lucidchart. Perfect time to give a bit more visibility on this number of users and follow-up on my article Add-ons and the Google Apps Marketplace from 2016.

Source: What’s behind the numbers in the G Suite Marketplace?

Subscribe to Apps Script Pulse...