In a previous post I introduced TSChatWise … a Google Sheets and Apps Script powered Google Chat tool for teaching and learning. 🚀 This post is the third post in a TSChatWise “Getting Started” series where I’ll discuss how to get started with TSChatWise.
We’ve feature TSChatWise in AppsScriptPulse in the past but worth revisiting as author Laura Taylor has created some resources to help you get started.
Source: TSChatWise — Getting Started
I like shortcuts! I’m in constant search of what I deem to be the most simple, efficient and effective shortcuts. I consider any tool, system or methodology which helps me streamline workflow and save precious time a shortcut. When I believe I’ve discovered (or perhaps created) a shortcut, especially a G Suite shortcut, I like to share that shortcut with others.
Take your G Suite organization’s education to the next level with TSChatWise … a Google Sheets and Apps Script powered Google Chat tool for teaching and learning. 🚀
Source: TSChatWise — A Google Chat Education Tool
TSFormBot is an Apps Script powered Google Form Hangouts Chat Bot which creates form submission webhook notifications for Hangouts Chat Rooms.
Need a structured ping on your Hangouts chat whenever someone submits a form? Laura Taylor has built a perfect solution with an ever more easier workflow documentation on how to implement it.
The article is an overview of the workflow covered in the author’s presentation along with install instructions for trying it out in your G Suite domain.
Source: G Suite Solutions — Apps Script Powered Workflow Automation
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 💥
As one of the only technologists in a family of CPAs I’m always seeking ways to participate in the discussion. So when the topic of using Benford’s Law as a risk assessment tool recently surfaced in conversation I decided to develop a custom macro to automate the analysis inside Google Sheets.
Laura Taylor tackles an interesting topic is this post highlighting how Benford’s Law can be used to detect anomalies in data. Google Apps Script developers might also be interested in the way macros are introduced to the reader.
Source: Using Apps Script, a Google Sheets Macro and Benford’s Law to Detect Potential Fraud
The challenge? Make this table powerfully configurable, simple to use, private to the client domain and employ existing G Suite tools.
After some dedicated design and development with Google Apps Script … 💥 TSDataTable!
Source: TSDataTable — Simple, Elegant Data Tables for Google Sheets & Sites