In this article, we’ll create a sample app which stores Feedback of user from the Flutter app into Google Sheets using Apps Script.
Gotchas, Solutions
Debugging in Google Apps Script – Jeff Everhart
| | 0 Comments |
Most of the comments I get on this site have to do with someone trying something I’ve written about that isn’t working for them. In most cases, error messages can be your friends since they can point to the particular place your script failed and give you additional insight into why it failed.
This post will describe some of the ways you can use the built-in tools of the Google Apps Script environment to debug or troubleshoot your own scripts. My goal here is start from the easiest to implement and work towards more difficult, but more efficient, methods of debugging.
Library
EncodeApp by tanaike (The Thinker)
| |
EncodeApp is a GAS library for retrieving the encoding set (charset) and doing URL encode with the specific encoding set using Google Apps Script (GAS). – tanaikech/EncodeApp
Library’s project key: 1DsJdRQ9D6nXgbxVVvOroM3EYJOcB197Isvt2Sl4sziW3m9IqqeB9YoWy
Source: tanaikech/EncodeApp
Solutions, Sheets
Get updated with 2019-nCoV (or any) real-time statistics with Google Sheets
| |
What if you want to catch up with the numbers regularly, say, in particular areas? Of course you can keep scrolling your phone for it, but there are chiller ways to do so.
In this 3-part series, Claire Chung explores the spread of pneumonia outbreak and explains how you can import & track data with Google Sheets, organize it & send notifications.
Source: Get updated with 2019-nCoV (or any) real-time statistics with Google Sheets.
Solutions, Gmail
Manage Gmail with Google Apps Script
| |
Ever had a messy inbox full of mails? Does it bother you to skip the inbox? Luckily, Google has provided many services that we can harness its utilities to organize the mail using personal preferences or workflow.
You will able to make an auto email archiver/remover after following the steps. This will be done by using Google Apps Script and setting the schedule trigger. The code is pretty simple and straightforward since Google has already provided us with ready-to-use objects for managing Gmail.
Source: Manage Gmail with Google Script
Gotchas, Solutions
GGvulnz — How to check your domain and groups settings
| | 0 Comments |
This article will highlight how you have to be careful about settings when you make some content available publicly, like Groups or Drive file.
The original article describe how an external person of the domain can subscribe to your Slack company channel by using a Google Groups that is publicly accessible. Stéphane Giron’s article helps answer the question – how to prevent and how to identify if some groups are concerned.
Source: GGvulnz — How to check your domain and groups settings
Solutions
How to get that inactive Twitter handle you really want using Google Apps Script
| |
You may have seen in the news that Twitter will begin deleting inactive accounts of users who hadn’t logged in within the past 6 months before Dec. 11, 2019.
This is bad news if you happen to be @qwerty123, but great news if — like me — you’ve found the perfect username but some clueless bovine has been accidentally hoarding it for the past 8 years.
In this post Sean Cann shows you how you can use Google Apps Script to detect when your preferred new Twitter handle becomes available.
Source: How to get that inactive Twitter handle you really want
Docs, Forms, Sheets, Slides
TSDynamicUrls (#1) — Leverage the URL Power of Google Docs, Sheets, Slides, Drawings & Forms 💥
| | 0 Comments |
In my previous post, I outlined the power of Google document URLs to perform “Simple, Powerful, Work” and promised to share several tools I’ve developed to aid in building them.
Source: TSDynamicUrls (#1) — Leverage the URL Power of Google Docs, Sheets, Slides, Drawings & Forms 💥
Solutions
How marketing teams can use Google Apps Script to automate tasks and expand their JavaScript skills
| |
Whether it’s event planning, research aggregation, budgeting, report creation, or reaching out to customers for campaigns; it’s helpful to be able to automate tasks using a script in Google Sheets for example.
Source: How marketing teams can use Google Apps Script to automate tasks and expand their JavaScript…
Solutions, Drive
Apps Script – Adding and removing Drive files and folders
| | 0 Comments |
In case you didn’t know, Google Drive has the ability to store files and folders in more than one place at a time. So, you could have a file in a folder for a particular company and have the same file in a different folder which is where you store all the reports. It’s something you can’t do in a traditional computer folder system.
Source: Apps Script – Adding and removing Drive files and folders