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.
… 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.
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!
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.
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.
Simplify the process of producing visually rich mail merges using Gmail and combining it with data from Google Sheets. With this solution you can automatically populate an email template created as a Gmail draft with data from Google Sheets. Merged emails are sent from your Gmail account allowing you to respond to recipient replies.
Have you ever created a Google Sheet projects where you could really use a select all checkbox (they call them ‘Tick-boxes’ in Google Sheets)? Sure you can copy a range of … Continue reading
Great post not only showing you how to make a ‘select all’ checkbox but you also get an in depth explanation of how this works. Once you fishish this post you might want to read this other Yagisanatode on How to check if there is a Tick Box (Check Box) in a cell or range
