Errata

Google Script: Enterprise Application Essentials

Errata for Google Script: Enterprise Application Essentials

Submit your own errata for this product.

The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color key: Serious technical mistake Minor technical mistake Language or formatting error Typo Question Note Update

Version Location Description Submitted By Date submitted Date corrected
PDF
Page 8
United States

Hello World Integrated (My first Google Script UI).

The original code snippet works fine and brings up "Hello World" however when adding the additional label the script editor states that "app" is not defined.

function helloWorld() {
var mydoc = SpreadsheetApp.getActiveSpreadsheet();
var application = UiApp.createApplication().setTitle('Hello World');
var helloWorldLabel = app.createLabel('My first Google Script UI');
app.add(helloWorldLabel);
mydoc.show(application);
}

Note from the Author or Editor:
The lines:
var application = UiApp.createApplication().setTitle('Hello World');
&
mydoc.show(application);


Should read:
var app = UiApp.createApplication().setTitle('Hello World');
mydoc.show(app);

James Carter  Feb 13, 2012 
PDF
Page 36
Sample code, centre of page

The sample code will not run as displayed because of nested quotes of the same type:

.setText('That's not an email')

The outer quotes need to be double quotes:

.setText("That's not an email")

Note from the Author or Editor:
Change quotes

Weehooey  Feb 07, 2012 
PDF
Page 41
first line of code

The line of code should end in a semi-colon.

Note from the Author or Editor:
Add a semi-colon. Will not error but should be there.

Weehooey  Feb 07, 2012 
Other Digital Version
50
United States

On page 50 of the Kindle version, in the section titled "Using the Public Google Script Objects Class", the author instructs you to copy and paste the open source library code.

Where is this open source library file that is discussed (and shown partially in Figure 5-4)?

The errata on the website doesn't talk about this. And I don't see any links for downloading source code from the O'Reilly site, either.

Note from the Author or Editor:
Libraries don't work like this any more. Information on the change can be found here. https://sites.google.com/site/scriptsexamples/custom-methods/gs-objects

Justin Ogden  Mar 03, 2012 
PDF
Page 57
doGet function block

The doGet function instantiates & returns application however through the rest of the cose for this script app is used.

Note from the Author or Editor:
The instances of application should be changed to app.

Pedro  Jul 22, 2012 
PDF
Page 59
Code block at bottom of page

The code line c++ should be c++;

Note from the Author or Editor:
c++;
This is the correct JS.

Pedro  Jul 22, 2012 
PDF
Page 65
1st sentence

"contained withing the script." - within spelled incorrectly

Note from the Author or Editor:
remove "g" from withing to make it within.

William Hughes  Feb 02, 2012 
PDF
Page 66
New Zealand

" by setting a the position to fixed"

delete a

Haydn Flower  Feb 07, 2012 
PDF
Page 67
New Zealand

"Tou may think"

it should be "You may think"

Haydn Flower  Feb 07, 2012 
PDF
Page 71
3rd paragraph, 2nd sentence

"making it is good tool "

should be

making it a good tool

Haydn Flower  Feb 07, 2012 
Printed
Page 94
First code block

Syntax error: Cannot find method addCallbackElement(. line: ? (line 4)

Change first code block on page to:

var searchBox = app.createTextBox();
searchBox.setName('searchBox')
.setId('searchBox')
.addKeyUpHandler(app.createServerHandler('searchView')
.addCallbackElement(searchBox));
searchGrid.setWidget(0,0, searchBox);

James Ferreira
James Ferreira
 
Feb 22, 2012 
PDF
Page 126
Creating a Workflow code sample

Random ID function needs a =

FILE.doGet.randomString function() {

should be

FILE.doGet.randomString = function() {

Haydn Flower  Feb 12, 2012 
PDF
Page 126
last paragraph

must pass the UI though the function?s arguments.

should be

pass the UI through

Haydn Flower  Feb 12, 2012 
PDF
Page 131
last line of code on page

then run the FILES.docs.loadFiles function


wfGrid.setWidget(4,1, FILES.docs.loadFiles(app, workflow.getDocsFolders()

FILES should be FILE as that is the proper name space

Note from the Author or Editor:
Typo remove 's' from FILES

Haydn Flower  Feb 12, 2012 
PDF
Page 141
First block of code

FILE_step_loadSteps should be FILE_steps_loadSteps

Haydn Flower  Feb 12, 2012 
PDF
Page 153
code under Figure 8-13

app.getElementById(FILE_doGet_mainGrid).setWidget(1,0, savedTable);

should be

app.getElementById('FILE_doGet_mainGrid').setWidget(1,0, savedTable);

or else it errors as FILE_doGet_mainGrid as undefined

Note from the Author or Editor:
Add quotes.

app.getElementById('FILE_doGet_mainGrid').setWidget(1,0, savedTable);

Haydn Flower  Feb 12, 2012 
Printed
Page 190
Figure A-8

Figure A-8 Submit button contains the same image as Figure A-9. File upload. The printed image in Figure A-8 is incorrect.

Note from the Author or Editor:
The image should be the new File chooser which was added after the book was published.

Anonymous  Feb 25, 2013