AppsScriptPulse

Updated Apps Script integrated development environment will replace the legacy experience by Q4 2022 | Release Notes | September 27, 2022

Apps Script has turned down the legacy integrated development environment (IDE) in favor of the redesigned IDE that launched in December 2020.

Google have announced the updated Apps Script editor will replace the legacy experience by Q4 2022. Whilst the new IDE was a huge step forward there are some core features from the old Script Editor, which will hopefully make it into the new IDE before Q4. The ones I hear most often are access previous script versions and search/replace across project script files. For the later in the meantime I recommend looking at the Black Apps Script Chrome extension. Whilst this extension primarily enables a true dark mode it also lets you search across script files.

Source: Release Notes | Apps Script | Google Developers

New behaviour in V8 runtime removing script order limitation | Release Notes | June 6, 2022

We’ve been a little remiss highlighting the latest Google Apps Script release notes, but in case you missed it there has been an update to the V8 runtime:

You can now call functions in separate files before they’re parsed. Previously, the V8 runtime required a script file to be parsed before any other file could call the functions it defines.

Now, the order of files in the Apps Script editor doesn’t matter. This means that you can call a function in a different file to assign a value to a global variable—the function is always defined before it’s called. This behavior reflects that of the legacy Rhino runtime.

See the source post for more details and an example code snippet.

Source: Release Notes | Apps Script | Google Developers

New features in the Apps Script integrated development environment (IDE) | Release Notes | April 13, 2022


April 13, 2022
You can now perform the following actions in the new Apps Script integrated development environment (IDE):

You can read more about the script editor updates in this related Google Workspace Updates post, which provides more details of note is:

This launch ensures Apps Script users can utilize the legacy features in the new environment:

  • Script Properties: Allows you to store simple data in key-value pairs scoped to one script. Script properties are typically used to store developer configuration data. The new IDE has now integrated the interface to edit, delete and create up to 50 new script properties.
  • Add-on Testing: Allows add-on developers to test their add-ons before publishing them broadly.
  • Time Zone Setting: Allows you to update the time zone of the script and its executions.
  • Rhino Debugging: Adds the ability to debug Rhino subroutines on V8 debugger, without migrating to V8. If the code is not V8 compatible, users will get a warning message.

Source: Release Notes | Apps Script | Google Developers

For Google Workspace Add-ons, an Attachment class has been added to the Card Service that lets you add custom attachments to Calendar events | Release Notes | March 24, 2022 | Apps Script | Google Developers

March 24, 2022

For Google Workspace Add-ons, an  Attachment  class has been added to the Card Service that lets you add custom attachments to Calendar events. You can also set an event trigger that fires when the user clicks on the add-on attachment provider in the Calendar dropdown menu. For more information, refer to  EventAttachmentTrigger .

You can read more about attaching files to Google Calendar events in this related Google Workspace Updates post:

Google Workspace developers can now create Google Workspace add-ons that attach files to a Google Calendar event from any third-party service. This feature enables developers to create add-ons that support attachments from a wide range of sources beyond Google Drive, such as digital whiteboard, content creation, or file management tools.

The update includes the following additional guidance for developers:

You can now develop add-ons that support attaching files from sources other than Google Drive. To get started, learn more about extending Calendar with Google Workspace add-ons and adding attachments with a callback function.

Source: Release Notes  |  Apps Script  |  Google Developers

The get methods for several color objects in the Spreadsheet Service have been deprecated | Release Notes | March 18, 2022 | Apps Script | Google Developers

March 18, 2022

The  get  methods for several color objects in the Spreadsheet Service have been deprecated in favor of a new naming convention. The functionality remains the same. For example, the  getFontColor()  method from the  Range  class has been replaced with  getFontColorObject() .

Check out the source link for details of which Spreadsheet Services have been updated.

Source: Release Notes  |  Apps Script  |  Google Developers

Owners receive email alerts when someone outside the owner’s organization edits a script project | Release Notes | February 14, 2022 | Apps Script | Google Developers

As a little experiment for Apps Script Pulse fans we are going to start reposting the official Google Apps Script release notes on this site. Why? The release notes can be incredibly useful to keep up-to-date with latest Google Apps Script developments but currently unless you keep checking the page (or know someone with an unofficial RSS feed), they can be hard to monitor.

The February 14, 2022 release note contains a very useful security update which will let yo know when someone outside your organisation updates a script project. Details and link below:

February 14, 2022

Owners receive email alerts when someone outside the owner’s organization edits a script project in the new integrated development environment (IDE).

  • For container-bound scripts: If someone outside the container owner’s organization creates or edits a container-bound script project, the container owner receives an email notification.
  • For standalone scripts: If someone outside the script project owner’s organization edits a standalone script project, the script project owner receives an email notification.

Source: Release Notes  |  Apps Script  |  Google Developers

Meet the Google Workspace Developer Experts – making connections with the community

Meet the Google Workspace Developer Experts, a global network of experienced technology experts, thought leaders, and influencers who actively support developer communities around the world.

If you are starting out on a new product, environment or beginning to learn to code finding people to connect with within an existing community can often be a challenge. Thanks to the efforts of Charles Maxson hopefully those connections are made a bit easier.

Source: Meet the Google Workspace Developer Experts

Get ready to up your Apps Script! – Google Developers Blog

The new Apps Script IDE features the same rich integration with Google Workspace as it did before, allowing you to get started building solutions without having to install or configure anything. If you are working on a standalone script project application, you can use the Apps Script Dashboard to launch your project directly, or if you are working on a container bound project in Sheets, Slides or Docs, you can do so from selecting Tools > Script editor from their top menus.

Charles Maxson, Developer Advocate Google Cloud, has highlighted some features Google Apps Script developers new and old should keep an eye out for. I think one of the big ones for experienced Apps Script developers who work mostly in the online editor is going to be the context menu options and the Command Palette. Find out more in the source post.

Source: Get ready to up your Apps Script! – Google Developers Blog

Quickstart: Check student attendance in Google Meet from a Google Classroom roster using Google Apps Script

Complete the steps on this page to create a Google Sheets add-on that tracks attendance for Google Classroom courses delivered using Google Meet conferencing.

Nice spot via @barrielroberts/@alicekeeler for an official Google Apps Script quickstart which combines Google Sheets, Google Classroom and Admin Reports which lets you create an automated Google Meets attendance roster tool. The quickstart has all the code and instructions you need to get this working.

Source: Quickstart: Check student attendance in Google Meet courses

Google Developers Blog: Building G Suite Add-ons with your favorite tech stack

Let’s talk about the basics of G Suite Add-ons. G Suite Add-ons simplify how users get things done in G Suite by bringing in functionality from other applications where you need them. They provide a persistent sidebar for quick access, and they are context-aware — meaning they can react to what you’re doing in context. … Up until recently, G Suite Add-ons leaned on Apps Script to build Add-ons, but choice is always a good thing, and in some cases you may want to use another scripting language.. So let’s talk about how to build Add-ons using additional runtimes.

Google recently announced the ability to develop G Suite Add-ons using other frameworks other than Google Apps Script. This post on the Google Developers Blog introduces how you can develop G Suite Add-ons with something other than Google Apps Script.

Source: Google Developers Blog: Building G Suite Add-ons with your favorite tech stack