Book Image

Learning Google Apps Script

By : Ramalingam Ganapathy
Book Image

Learning Google Apps Script

By: Ramalingam Ganapathy

Overview of this book

Google Apps Script is a cloud-based scripting language based on JavaScript to customize and automate Google applications. Apps Script makes it easy to create and publish add-ons in an online store for Google Sheets, Docs, and Forms. It serves as one single platform to build, code, and ultimately share your App on the Web store. This book begins by covering the basics of the Google application platform and goes on to empower you to automate most of the Google applications. You will learn the concepts of creating a menu, sending mails, building interactive web pages, and implementing all these techniques to develop an interactive Web page as a form to submit sheets You will be guided through all these tasks with plenty of screenshots and code snippets that will ensure your success in customizing and automating various Google applications This guide is an invaluable tutorial for beginners who intend to develop the skills to automate and customize Google applications
Table of Contents (16 chapters)
Learning Google Apps Script
Credits
About the Author
About the Reviewer
www.PacktPub.com
Preface
Index

Creating a document reviewing and instant inline commenting application


We will create a document reviewing and commenting application. The document can be an article submission, a comprehension submitted by a student, a thesis paper submitted by a researcher, or anything else that should be reviewed before acceptance. The reviewer can review and insert predefined comments or his/her own custom comments, instantly. The reviewer selects some text in the document, and clicks on any one button (predefined comments) to highlight. Then, the script will highlight the text and insert the comment text inline along with creating an actual comment. You can see the created comments in the Comment panel (at the top right-hand side). Finally, the reviewer can insert score at the end of the document.

As usual, create the onOpen trigger function in the code file, and it will open the sidebar:

function onOpen() {
  var ui = HtmlService.createHtmlOutputFromFile('Sidebar')
    .setTitle('Review and Comment...