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 a clickable button

In the previous chapter, you learned how to open the script editor in Google Sheets. For this task, open the script editor in a newly created or any existing Google Sheet and follow these steps:

  1. Select cell B3 or any other cell. Click on Insert and select Drawing..., as shown in the following screenshot:
    Creating a clickable button
  2. A drawing editor window will open. Click on the Text box icon and then click anywhere within the canvas area. Type Click Me. Resize the object to enclose the text only, as shown in the following screenshot:
    Creating a clickable button
  3. Click on Save & Close to exit the drawing editor. Now, the Click Me image will be inserted into the active cell (B3), as shown in the following screenshot:
    Creating a clickable button

    You can drag this image anywhere around the spreadsheet except in the menu bar.

    Tip

    In Google Sheets, images are not anchored to a particular cell, and they can be dragged or moved around.

    If you click on the image, a drop-down arrow on the top-right corner will be visible:

    Creating a clickable button
  4. Click on the Assign script…...
You have been reading a chapter from
Learning Google Apps Script
Published in: Mar 2016
Publisher:
ISBN-13: 9781785882517
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