AppsScriptPulse

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...