AppsScriptPulse

Create a simple Approval process via Email with Google Form and Google Apps Script (Web Apps Deployment)

At the end of this article, you will know how to create a workflow app, based on a Google Form that send an email to be approved or deny including logging of who is approving or denying with Apps Script.

Great post from Jérémy Dessalines who has put together this tutorial for a custom workflow using a Apps Script Web App. The post covers triggers, the publication process and how to generate a unique ID and includes some great tips at the end.

Source: Create a simple Approval process via Email with Google Form and Google Apps Script (Web Apps…

Follow the trend of Apps develop in your org with a Dashboard of the default Cloud SQL App Maker Instance

Adoption dashboard

Image credit: Jérémy Dessalines https://link.medium.com/yqklXl2p22

Monitoring Google App Maker adoption in our Organisation. For this I realized an Apps Script project calling the Cloud SQL Admin API, a REST API for administering your instances programmatically in order to Lists instances under a given project in alphabetical order by instance name.
Data will be displayed on a DataStudio dashboard.

Source: Follow the trend of Apps develop in your org with a Dashboard of the default Cloud SQL App Maker Instance

Create a game web-app fast with Google App Maker ? Challenge accepted.

Google App Maker allow you to create responsive web-app fast in your company. What about create an internal challenge ?

In this post Jérémy Dessalines highlights the benefits of using Google App Maker to rapidly develop a web based game and all in a couple of lines of code:

The app benefits from Google App Maker to authenticate the user, create a responsive application that allows the visualization of good practices in the form of cards. … Access is secure and restricted to a small group of users via a Google Group.

Source: Create a game web-app fast with Google App Maker ? Challenge accepted.

How to design advanced Google App Maker apps with BigQuery API, Google Groups, Google Data Studio and Cloud SQL

Where should I store my data? Should I sync Cloud SQL and Big Query? How to publish my app,… Read on Jérémy Dessalines’s (@Gr3m) thoughts on working with App Maker.

Source: How to design advanced Google App Maker apps with BigQuery API, Google Groups, Google Data Studio and Cloud SQL

Digitize Mail & Parcels Tracking with Google App Maker

A few months ago my team was challenged to digitize the work of the General Services Department in our offices. To improve the process we created a Google App Maker web-app designed to be used on Chromebooks in tablet mode. To track usage and movements, Cloud SQL stores data in tables: packages, movements/history and anomalies declared by teams. In order to retrieve the hexadecimal code of the badge, it’s really easy. A card reader behaves like a keyboard !

Source: Digitize Mail & Parcels Tracking with Google App Maker