Google Apps Script for Beginners by 2014

Author:2014
Language: eng
Format: mobi
Publisher: Packt Publishing

Site gadget's limitations/restrictions/use cases

Site-embedded web applications are a nice way to give access to your script functions because they enable easy page navigation and the possibility to add descriptions, directions for use, and illustrations, making your apps easier for other users to use.

If we think about the very first script example in Chapter 1, Enhancing Spreadsheets, that calculated my age in hours and that we tried in a spreadsheet, the same script modified to work as a site gadget would be much more fun and easy to make public without us needing to share any access to any of our documents. Moreover, even a user having no experience with spreadsheets would be able to use it without difficulty.

The code will need to be changed to create a small and basic user interface so that users can enter their birth date and time. This requires a few methods and a workflow, which we haven't talked about yet (it is for the next chapter), but for now you can simply copy it and follow the instructions and leave the "understanding" bit for later!

The code has two parts: one part that creates the user interface to enter values and a second that retrieves the values, does the calculations, and shows the result in the same UI.

The first part of the code is as follows; simply copy it as it is:

function doGet() { var app = UiApp.createApplication().setTitle('Age In Hours'); var grid = app.createGrid(3,2); var handler = app.createServerHandler('myAgeInHours').addCallbackElement(grid); var time = app.createListBox().setName('time').addItem('Choose the hour',-1); for(var n=0 ; n<24 ; n++){time.addItem(n+' h',n)}; var date = app.createDateBox().setName('date'); var button = app.createButton('Show me...',handler); grid.setWidget(0,0,date).setWidget(0,1,time).setWidget(1,0,button); app.add(grid); return app; }

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.