Apps Script is handy for automating Google Apps tasks, but it also serves as a complete application platform. With this book, you’ll learn how to build, store, run, and share data-driven web apps right on Google Drive. You’ll have access to complete code and working examples that show you how everything fits together.
Build an interactive Web App UI that runs on most web and mobile browsers
Create a sample product catalog that displays custom data from a spreadsheet
Develop an application to generate web forms from templates
Use Apps Script to build a simple web-based database application
Design a document workflow builder that users can quickly customize
Create a Google form that lets you select and send email responses
Debug your code and keep track of script problems after deployment
James Ferreira managed public communications for two successful state political campaigns; served as the Chief Information Officer for the New Mexico Office of Attorney General; migrated the first government agency to Google Apps; speaks at conferences across the nation about implementing new technology; wrote software to extend Google Apps that serves more than half a million users worldwide and published numerous technology articles including the Google Enterprise blog.
The animal on the cover of Google Apps Script, 2nd edition is a Black-throated BlueWarbler (Setophaga caerulescens). This common songbird is native to North America,and it prefers areas with large forests or uninterrupted woodland. While the Warblerpopulation in North America is stable and growing, deforestation threatens its wintermigratory areas and could eventually have a negative impact on the future of the species.The German naturalist Johann Friedrich Gmelin first described Black-throated BlueWarblers in 1789; its species name, caerulescens, comes from the Latin meaning “turningblue.” The male of the species has an inky blue back and head, with a bright white bellyand a black throat. Unfortunately, the female is not so colorfully arrayed: she has anolive-brown back and pale yellow underparts.As a species of songbird, the male Warbler attracts a mate through singing; once a femaleresponds, the two will be monogamous for the breeding season, which runs from Maythrough July. Due to their diet of insects supplemented by berries and seeds, the Warblerbuilds a nest close to the ground. They prefer woodland that is very dense so that theirnests will be better protected from predators by scrub and overgrowth.After a pair has bonded, the male will often guard the female closely, following heraround as she forages for food and collects materials with which to build the nest. Nearthe end of the mating season, males who were able to create offspring will stay with thenest and sing a special post-breeding song; those that could not find a mate abandontheir areas. This behavior allows the males to demonstrate their success and helps femaleskeep track of good nesting and breeding habitats.