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