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.
| 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
|
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 |
|
