Google Apps Script for Beginners by Unknown
Author:Unknown
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
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.
ActiveX | ASP.NET |
Cold Fusion | CSS |
DHTML | Java Server Pages |
JavaScript | PHP |
Python | Ruby |
XSL |
Hello! Python by Anthony Briggs(9914)
The Mikado Method by Ola Ellnestam Daniel Brolund(9777)
Dependency Injection in .NET by Mark Seemann(9337)
Sass and Compass in Action by Wynn Netherland Nathan Weizenbaum Chris Eppstein Brandon Mathis(7778)
The Well-Grounded Java Developer by Benjamin J. Evans Martijn Verburg(7557)
Svelte with Test-Driven Development by Daniel Irvine(7150)
Test-Driven Development with PHP 8 by Rainier Sarabia(6877)
Layered Design for Ruby on Rails Applications by Dementyev Vladimir;(6744)
Secrets of the JavaScript Ninja by John Resig & Bear Bibeault(6532)
Secrets of the JavaScript Ninja by John Resig Bear Bibeault(6413)
Web Development with Django by Ben Shaw Saurabh Badhwar(6212)
React Application Architecture for Production by Alan Alickovic(5935)
Jquery UI in Action : Master the concepts Of Jquery UI: A Step By Step Approach by ANMOL GOYAL(5806)
Kotlin in Action by Dmitry Jemerov(5062)
Audition by Ryu Murakami(4583)
Software Architecture for Web Developers by Mihaela Roxana Ghidersa(4447)
Hands-On Full-Stack Web Development with GraphQL and React by Sebastian Grebe(4316)
Accelerating Server-Side Development with Fastify by Manuel Spigolon Maksim Sinik & Matteo Collina(4295)
Functional Programming in JavaScript by Mantyla Dan(4038)
