AppsScriptPulse

Add-on, Official News, Sheets

G Suite Updates Blog: Goal Seek add-on now available for Google Sheets

Tags:
| | 0 Comments |

You can use the Goal Seek add-on to calculate the required value of a cell to achieve a desired value in another cell. This is particularly useful when conducting break-even analysis or sensitivity calculations, like determining how changing one value affects other correlated values in your sheet.

Interesting to see Google extending the functionality of Google Sheets with this official add-on

Source: G Suite Updates Blog: Goal Seek add-on now available for Google Sheets

Add-on, Solutions, Forms, Sheets

Create a Branching Google Form – Teacher Tech

Tags:
| | 0 Comments |

Alice Keeler’s architecture on designing your Google Forms to provide immediate feedback by utilizing branching options is fascinating and efficient.

Create multiple sections in your Form and add only one question per section that determines which section to jump to next. Answer correctly and the branching should take the student to the next question. Answer incorrectly and be taken to a section with a tutorial or hint and a chance to answer a new question.

Source: Fast: Create a Branching Google Form – Teacher Tech

Solutions, Forms, Sheets

How to use Google Sheets and Google Apps Script to build your own blog CMS

Tags:
| | 0 Comments |

Build a “Content Management System” (CMS) for an online blog using Google Sheets, Google Forms, and Google Apps Script.

Source: How to use Google Sheets and Google Apps Script to build your own blog CMS

Solutions, Calendar, Sheets, Web App

Gym Attendance App built with Google App Script and React

Tags:
| |

Edward Meehan created a Gym Attendance web app using Google App Script and React that logs members attendance to be used for members and class metrics.

Source: Gym Attendance App built with Google App Script and React

Solutions, Sheets

How to use Google Spreadsheet as Admin Interface for your Firebase project

Tags:
| | 0 Comments |

Manage, verify and approve transactions in your application using cloud functions and Google Apps Script.

Nice little tutorial showing two communication between Google Sheets and Firebase using Google Apps Script.

Source: How to use Google Spreadsheet as Admin Interface for your Firebase project

Solutions, Sheets

I created a Twitter Bot from nothing but a Google Sheet – And I Didn’t Even Know The Scripting Language…

Tags:
| | 0 Comments |

… that job taught me two very important lessons: repetitive stuff needs to be automated; the best way to learn to code is with a tangible, objective problem that needs a solution. … It was then I decided to go all-out and make a Twitter Bot. Having no relevant experience or clue of what I was doing, my goal was simple: send a few tweets with relevant quotes, readings, and information for Orthodox Christians

Very detailed post from Peter Berthelsen on his journey from no-code to making a functional Twitter bot and if you keep reading to the end you’ll get a link to Peter’s follow-up post with a template and setup instructions. These posts are great examples of the empowerment Google Apps Script can give to people.

Source: I created a Twitter Bot from nothing but a Google Sheet

Official News, App Maker, Sheets

Example apps you can build on Google App Maker – Sheets to Apps – YouTube

Tags:
| | 0 Comments |

In this episode, we give you some brief examples of what kind of apps you can create with App Maker. Learn how to build dashboards, human resource apps, and so much more!

Solutions, Sheets

Using Apps Script, a Google Sheets Macro and Benford’s Law to Detect Potential Fraud – Laura Taylor

Tags:
| | 0 Comments |

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

Library, Solutions, Sheets

BkperApp – An example 3rd party client library for Google Apps Script 

Tags:
| | 0 Comments |

Google Apps Script library for Bkper.

Bkper “provide a simple way to work with Finances and Accounting on Google Cloud”. The BkperApp is a Google Apps Script library they have published so that other developers have an easy way to interact with the Bkper API. There are a couple of reasons for highlighting BkperApp. First it’s great to see a company invest in developing and publishing a Google Apps Script library for their product. The BkperApp code is worth looking at because the code has been developed in clasp using TypeScript. Finally the code is open source (Apache License 2.0) so if you are thinking of developing a library for your own product BkperApp might provide a useful starting point in terms of how you structure your project.

Source: bkper/bkper-app

Solutions, Sheets, Sites

TSDataTable — Simple, Elegant Data Tables for Google Sheets & Sites – Laura Taylor

Tags:
| | 0 Comments |

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