LinkedInTwitterFacebook

Google Apps Script – Creating UI – part 001.

What is the Google Apps Script?

It’s a JavaScript cloud scripting language that extends Google Apps and provides easy ways to automate tasks across Google products and third party services.

So you can deal with all google products like docs , gmail , calendar , maps etc. to make all good for you.

Now it’s three ways users access UI developed in Apps Script :

– google spreadshet

– google sites

– standalone – can be accesed by URL

It’s two types of apps Script UI Objects.

+panels

-form panel

-horizontal panel

-vertical panel

-flow panel

-… and more

+widgets

-text box

-labels

-buttons

-check boxes

-text area

-radio buttons

-… and more

How to using panles in the right way…

First you need to create the application.See the script:

You can also create one horizontal panel

… or maybe if you want an flow panel

Let’s make one simple script example to show you how to do it.

First open one new spreadsheet in your google drive account.

Go to Menu – Tools -> Script Editor , see the next image:

appscript-001

Select Blank Project …

appscript-002

You will have one new tab in your browser , this will be the editor to write your script.

appscript-003

Write now in this editor this script.

Save the script and try to run button (will see something like one play button in the menu).

First time when you try to run project will need some authorization. Be agree.
http://free-tutorials.org/wp-content/uploads/2013/08/google apps script authorization
In the tab browser with your spreadsheet will see this:

appscript-004

The next step is to make one function to handle user action.

The handlers are used to wire user response to Apps Script functions.

This it’s the full source script :