AppsScriptPulse

Community News

Totally Unscripted: Get AMPed about Email – Thur 21 Jan at 1200 PST / 1500 EST / 2000 UTC

Tags:
| | 0 Comments |

Totally Unscripted is back again on Thur 21 Jan at 1200 PST / 1500 EST / 2000 GMT. This time we will be joined by Jon Harmer (Product Manager, Google Workspace) and Steve Bazyl (Developer Relations, Google Cloud) who will give an overview of  how you can start using AMP with your Google Workspace Gmail users and beyond. 

Unfamiliar with AMP for email? This “allows senders to include AMP components inside rich engaging emails, making modern app functionality available within email. This dynamic email format provides a subset of AMPHTML components for use in email messages, that allows recipients of AMP emails to interact dynamically with content directly in the message” [ref] 

Tune in live to contribute to the YouTube live chat (recording immediately available)

For previous episodes, information and resources visit https://tu.appsscript.info/

Solutions, Web App, Beginner

Synchronous Class Dashboard with Apps Script – a personalized online interactive classroom

Tags:
| | 0 Comments |

Andy Rundquist has created (and released as open source!) a synchronous class dashboard built entirely out of Apps Script.

As my school went mostly online last spring, I started collecting my thoughts about what I really wish I had for an online platform to work with my students. I quickly realized that my dream of all videos on and fully interactive students 1) wasn’t as good as I thought, and 2) didn’t happen because many students couldn’t or wouldn’t make use of video. I began to realize that video is the dominant feature in things like Zoom and Google Meets. It gobbles up nearly all of the screen space and is responsible for nearly all the bandwidth. So I started to consider what I might be able to do if I just stopped using video.

So I set out looking for ways to build in collaborative tools like whiteboards and understanding checks that would make better use of screen space. This is the result.

https://github.com/arundquist/synchronous-dashboard-with-jitsi

Andy’s full project is on GitHub is worth checking out.

Community News

Trend of google-apps-script Tag on Stackoverflow 2021

Tags:
| | 0 Comments |

Year vs. number of Questioners and Answerers. These all questions include the tag of "google-apps-script" in the tags

Year vs. number of Questioners and Answerers. These all questions include the tag of “google-apps-script” in the tags

Trend of google-apps-script Tag on Stackoverflow 2021

Kanshi Tanaike returns with an updated look at trends in the [google-apps-script] tag on Stackoverflow.  A highlight from the report is the continued growth in new questioners, indicating that the Google Apps Script community is continuing to grow.

Source: Trend of google-apps-script Tag on Stackoverflow 2021

Community News

Workspace Devs Directory – a new community initiative to help Google Workspace and Apps Script developers connect

Tags:
| | 0 Comments |

Directory | Workspace Devs

A directory of Google Workspace and Apps Script Developers.

This space is to help bridge that gap within the Google Workspace (previously, G Suite) Developers community and mostly geared towards users who work within the Apps Script ecosystem.

Sourabh Choraria has created a new initiative to help Google Workspace and Apps Script developers connect. Anyone can submit their profile to be included in the directory.

Source: Directory | Workspace Devs

Community News

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

Tags:
| | 0 Comments |

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

New IDE, Solutions

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

Tags:
| | 0 Comments |

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

Solutions, Drive, Forms, V8, Beginner

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

Tags:
| | 0 Comments |

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

Community News

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

Tags:
| | 0 Comments |

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.

Solutions, Sheets, V8, Intermediate

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

Tags:
| | 0 Comments |

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