Search icon CANCEL
Subscription
0
Cart icon
Your Cart (0 item)
Close icon
You have no products in your basket yet
Arrow left icon
Explore Products
Best Sellers
New Releases
Books
Videos
Audiobooks
Learning Hub
Conferences
Free Learning
Arrow right icon
Arrow up icon
GO TO TOP
Learning Google Apps Script

You're reading from   Learning Google Apps Script Customize and automate Google Applications using Apps Script

Arrow left icon
Product type Paperback
Published in Mar 2016
Publisher
ISBN-13 9781785882517
Length 232 pages
Edition 1st Edition
Arrow right icon
Author (1):
Arrow left icon
Ramalingam Ganapathy Ramalingam Ganapathy
Author Profile Icon Ramalingam Ganapathy
Ramalingam Ganapathy
Arrow right icon
View More author details
Toc

Table of Contents (11) Chapters Close

Preface 1. Introducing Google Apps Scripts 2. Creating Basic Elements FREE CHAPTER 3. Parsing and Sending E-mails 4. Creating Interactive Forms 5. Creating Google Calendar and Drive Applications 6. Creating Feed Reader and Translator Applications 7. Creating Interactive Webpages 8. Building a Workflow Application 9. More Tips and Tricks and Creating an Add-on Index

Creating Forms using script


In Chapter 1, Introducing Google Apps Scripts, you created a Form manually, but this time we will create Forms programmatically by script. First of all, we will create a Form with four choices and an Other option choice. For simplicity, we add places as a multiple choice radio group. Each choice is exclusively selectable. Create the function createForm as shown here in a spreadsheet code file:

function createForm() {
  
  var places = ["Place 1","Place 2","Place 3","Place 4"];

  var form = FormApp.create("Vacation Form");
  
  form.addMultipleChoiceItem()
    .setTitle('Where will you go for vacation?')
    .setChoiceValues(places)
    .showOtherOption(true);
  
}

The places variable holds a few random places, and you can assign any place name and any number of places as an array of strings. The create method of FormApp class creates a form titled Vacation Form in your Drive's root folder (My Drive). On running the function, the created Form will look like this...

lock icon The rest of the chapter is locked
Register for a free Packt account to unlock a world of extra content!
A free Packt account unlocks extra newsletters, articles, discounted offers, and much more. Start advancing your knowledge today.
Unlock this book and the full library FREE for 7 days
Get unlimited access to 7000+ expert-authored eBooks and videos courses covering every tech area you can think of
Renews at $19.99/month. Cancel anytime