Whether you’re moving from Microsoft Office to Google Docs or simply want to learn how to automate Docs with Google Apps Script, this practical guide shows you by example how to work with each of the major Apps Script services.
Bruce Mcpherson the author of Going Gas has recently highlighted in the Google Apps Script Community that a chuck of his book is currently available for free in the Google Books preview (133 of the 456 pages are available). Bruce highlights that since publication in 2016 there have been a number of changes in Google Apps Script most notably the move to modern JavaScript syntax in the V8 engine, but much of the content may still be of interest.
Last September, Tables launched in Area 120, Google’s internal incubator for experimental projects, with the goal of proving market demand for a solution to help teams organize and track work, and it was a success! Google Cloud has committed to investing in this product area long-term. Moving forward, the beta version of Tables will still be available until we release a fully-supported Google Cloud product – which we expect to complete in the next year.
If you are not familiar with the Tables Beta it is a collaborative data platform designed to make it easier for no/low coders to create workflows and automations. If you would like to see the Tables beta in action Co-founder & Product Lead, Carlin Yuen, joined us on Totally Unscripted in New workflow solutions with Tables and Google Apps Script.The Tables beta has so far been limited to users in the US. The source link provides more details about timelines and how non-US users can join the beta. [HT Ivan Kutil]
Sometimes things fail — that’s a fact of life and programming. So as a programmer, you’re going to have to write error-handling code. Thankfully TypeScript has some handy features which can help us to create simple and maintainable error-handling code.
James Elderfield recently joined us on Totally Unscripted to share some insights into the infrastructure used at Supermetrics used to support the development of their Google Sheets Add-on and Data Studio Connector. As part of their stack James highlighted how they used TypeScript to write code complied to use in Google Apps Script. This post isn’t Apps Script specific but provides some useful tips on using TypeScript for error handling.
Questa funzionalità permette di visualizzare, insieme al messaggio del bot, una tastiera virtuale con una serie di bottoni dove gli basterà cliccare su uno di essi per scegliere la sua risposta
[Google Translate: This feature allows you to view, together with the message of the bot, a virtual keyboard with a series of buttons where it will be enough to click on one of them to choose its response]
The accompanying video and post for this solution are in Italian and Google Translate might be required. This is a great resource and another example of a high quality video produced by the Apps Script community. The solution provides an overview of how you can display an inline keyboard within a Telegram Bot using a single Google Apps Script project.
Video showing the Properties and Cache Services available for Google Apps Script
The Properties and Cache Services are designed to hold data for use beyond a single run of a script.
The Legacy IDE had an option to see view and directly interact with the Script Properties. This is not available in the new IDE but the service still exists and can be interacted with via code.
The primary difference between the PropertiesService and CacheService is that key-value pairs in the Cache are automatically deleted after 25 minutes, while data in the PropertiesService persist until deleted via code (or manually from the Legacy IDE)
Interesting to see a growing number of video tutorials being produced by the App Script community. The latest we’ve come across comes from Spencer Farris who in this post provides an overview of the Properties and Cache service. Click through to the source post to watch the video and access additional resources.
How to create filters in Google Sheets using Google Apps Script.
There are lots of ways you can filter data in Google Sheets and in this post Aryan Irani uses SpreadsheetApp.newFilterCriteria() to create a filter and then copy the filtered data to a new sheet. The post contains everything you need to know to filter data in this way.
You’ve written a great Apps Script library and you want to know how many people are using it, and perhaps even which parts of the library they are using, and how often. Perhaps you have a new version out, and need to know whether anybody is still using the old version. You may also have a set of libraries and you want to know whether users have flipped to the new version. All these things are important to know, but impossible to find out using the Apps script platform as is.
Bruce Mcpherson provides a detailed solution for tracking Google Apps Script library usage using the Properties Service. The source post contains everything you need to integrate this solution into your existing libraries as well as a quick way to chart usage.
Habitica is a self-improvement web application with game mechanics overlaid in order to help the player keep track of and remain motivated to achieve their goals.
The game is laid out in the form of an RPG, in which the player collects items such as gold and armor to become more powerful. Rewards are achieved through maintaining real-life goals, in the form of Habits, Dailies, and To-Dos.
Can’t say that I’ve come across the self-improvement web app Habitica before, but good to know there is a long list of Google Apps Script powered extensions, add-ons, and customizations.
How to use the Notion API with Google Apps Script to connect Gmail, Google Forms, and Google Sheets with your Notion workspace.
Notion, my absolute favorite tool for storing all sorts of things from web pages to code snippets to recipes, just got better. They’ve released a public API and thus it will be a lot easier for developers to read and write to their Notion workspace from external apps.
For note keeping fans of Notion Amit Agarwal shares some basic code to interact with the Notion API. Amit also has wrapped this into a new private beta Gmail Add-on that you can see in the post with a link to request early access.
