AppsScriptPulse

Google to offer free training courses in AI, Kubernetes and multi-cloud | IT PRO

Image: © Google Cloud

The cloud giant is offering 30 days of free training and routes to certification.

Budding learners can access all of these through a set of ‘skills challenges’ which give participants greater knowledge of each subject and a chance to earn a Google skill badge to prove their competency.

Participants will have 30 days of free access to Google Cloud Labs to work their way through four skill challenges: ‘Getting Started’, ‘Data Analytics’, Hybrid and Multi-cloud’ and finally ‘Machine learning and Artificial Intelligence’.

The Data Analytics course is for more experienced participants to expand their skills into AI and machine learning with a chance to demonstrate an understanding of BigQuery. They can learn how to do everything from writing and troubleshooting SQL queries and using Apps Script, to building classification and forecasting models.

IT PRO has picked up on some free training from Google, which includes an opportunity to use your Google Apps Script knowledge in the Data Analytics course. To start the challenges you need to register by January 31, 2021, 11:59 PT.

Source: Google to offer free training courses in AI, Kubernetes and multi-cloud | IT PRO

Google Apps Script GitHub Assistant (GasHub) updated for the new IDE

GasHub is a popular open source Chrome extension which lets you use GitHub for your code version control. This solution is the creation of @terryleonhart and not an official Google solution and as such there was some backend work to get the tool to work with the new Apps Script editor. This work has now been completed and developers can continue to enjoy using this excellent tool. To install and find out more click through the source link:

Source: gas-github

How to Move Files Uploads from Google Forms to a Specific Folder in Google Drive – Digital Inspiration

The File Upload feature of Google Forms lets you receive files from form respondents directly in your Google Drive. You may add the File Upload question in your Google Form to receive PDF assignments from students, résumé applications, portfolio images from contestants, and so on.

When a respondent uploads a file through Google Forms, the file are stored in a fixed folder of your Google Drive. All files are uploaded in the same folder and, thus looking at the file in your Google Drive, it is difficult to determine which respondent has uploaded which set of files.

Learn how to organize file uploads and attachments from Google Forms and move files to a specific folder in Google Drive.

Source: How to Move Files Uploads from Google Forms to a Specific Folder in Google Drive – Digital Inspiration

Totally Unscripted: A 2020 Google Apps Script recap for Google Workspace solution builders – Thur 14 Jan at 1200 PST / 1500 EST / 2000 UTC

Totally Unscripted returns and we kick off the year looking at some of the highlights and developments you may have missed in 2020 for Google Workspace solution builders. Our panel includes Olaf Hubel, Google Workspace Developer Relations Manager, and other noted experts from the community. As well as looking at Workspace highlights from 2020 we’ll look at what might be in store for 2021. Tune in live to contribute to the live chat.

How to send Slack alerts from Google Sheets / Google Apps Script

We run a lot of things through Google Sheets and Slack here at August. It’s a way of connecting and sharing information quickly and transparently with our clients and our team. We’ve put together a cheat sheet of a few simple Google Apps Script functions, along with the Slack API, so you can do the same.

Great post if you are looking for a quick start for interacting with Slack using Google Apps Script. As well as a detailed ‘how-to’ the post also includes a video walkthrough to help if you get stuck with any of the steps.

Source: How to send Slack alerts from Google Sheets / Google Apps Script. | August

5 Great Features in the new Google Apps Script Editor for Beginners

The new editor (Integrated Development Environment — IDE) for Google Apps Script is out! There is a lot of features in the new editor to make your lives easier; here’s my top 5 favorites that I think are helpful for beginners to write and manage their scripts.

We’ve reshared a number of community contributions about the new Apps Script IDE, but this is the first we’ve seen that is specifically targeted at beginners. As well as useful functionality within the IDE Cleo also shares some of her tips which should help writing code easier.

Source: 5 Great Features in the new Google Apps Script Editor for Beginners

When the Best Google Sheet is the One You Don’t Make

How to build a more perfect workflow for data updates and changes by coding in Apps Script between the Sheets

Thought provoking post by Max Brawer exploring the utility and fragility of using spreadsheets as part of a decision making processes and how Apps Script can be used to overcome some of these shortcomings.

Source: When the Best Google Sheet is the One You Don’t Make

How to write a custom function library for Google Sheets

In this article I will showcase one of the many ways you can customize your Google Workspace environment. We will implement two custom functions in Google Sheets. With these functions as an example I will demonstrate how to use Google Apps Script Libraries to organise and distribute your solution. There are multiple ways to distribute your Apps Script code within the Google Workspace, and this article will help you decide if this library method is right for you.

Always nice to have some advanced techniques in your toolbox. In this example from Jasper Duizendstra he explores how custom functions in Google Sheets can be packaged and used in Libraries.
Source: How to write a custom function library for Google Sheets

Totally Unscripted: Becoming a Google Workspace Solutions Gallery contributor – Thur 17 Dec at 1200 PST / 1500 EST / 2000 UTC

In this session we will have a look at the Google Workspace Solutions Gallery. “The Google Workspace Solutions Gallery is a collection of sample solutions that demonstrates how you can solve common business challenges with Google Workspace Developer technologies. These samples showcase different ways to integrate and customize the productivity tools you’re already using.” – https://developers.google.com/gsuite/solutions

As part of the Gallery anyone can suggest new solutions and we speak Jasper Duizendstra who has contributed the Record time and activities in Calendar and Sheets solution. We speak to Jasper about his experience summitting and getting a solution published.

Deploy easily with the new Google Apps Script IDE

A week ago Google announced the availability of an improved code editor for Google Apps Script. … In this article, I’ll focus on the changes related to Versions and Deployments in Apps Script.

Post from Romain Vialard unpicking deployments with the new Apps Script IDE. Romain highlights lots of very useful tips and things to be aware of when deploying Apps Script projects, in particular:

For existing scripts, deploying from the new IDE will create a new deployment with a different url for your web app

Source: Deploy easily with the new Google Apps Script IDE

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

16 secrets tips, tricks and features for new Google Apps Script Editor (v2020)

Google Apps Script has a new editor, which is better, nicer, and completed ready for future new features. Today, I would like to introduce you to several dirty and secret tricks, what you can do.

If you like a keyboard shortcut you’ll love this post from Ivan Kutil! For those less keen on keyboard commands there is still plenty of other productivity tips from Ivan shared in this post.

Source: 16 secrets tips, tricks and features for new Google Apps Script Editor (v2020)

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

How to get the most out of the new Google Apps Script debugger and logging

Building and maintaining code can be hard. There are multiple phases in the livecycle of the code, each phase with its own challenges. Being able to easily retrieve information about the execution of your code in each phase is key. This is where the new Google Apps Script IDE debugging and logging features can help. In this article I will show you what you can do with the new debugging and logging features.

Some great tips from Jasper Duizendstra on using the logging and debugging features of the new Apps Script IDE.

Source: How to get the most out of the new Google Apps Script debugger & logging

Guide To The New Google Apps Script IDE Covering 135 Features

Explore the fantastic new Google Apps Script IDE and see features that will make your life easier, whether you’re a beginner or pro developer.

Ben Collins can never be accused of slacking off and this post is the perfect example. As announced on Totally Unscripted the new Apps Script IDE is rolling out and Ben lists 135 features for developers to look out for. View the source post for these features plus a video of Ben highlighting his favorites.

Source: Guide To The New Google Apps Script IDE Covering 135 Features

Subscribe to Apps Script Pulse...