Errata

Google Apps Script

Errata for Google Apps Script

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.

The following errata were submitted by our customers and have not yet been approved or disproved by the author or editor. They solely represent the opinion of the customer.

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

Version Location Description Submitted by Date submitted
ePub Ch 3: Contact Me > Getting Started

index.html from chapter 3 has the following form with the ID in the div tag

<div id="subscribe_form">
<form>
<input type="email" name="email" placeholder="Enter your email">
....

Later on in the chapter the code is summarized as follows:

<div>
<form id="email_subscribe">
<input type="email" name="email" id="email" placeholder="Enter your email">
...

Once the user gets to chapter 4: The Concept of the Callback and incorporates...

google.script.run.withSuccessHandler(function(ret){
console.log(ret);
}).addEmail(this);

into index.html the example will fail with the following error in the JavaScript console

Uncaught InvalidArgumentError: Failed due to illegal value in property: 0

If the user is working with their own code they may not notice that the author changed the location of the ID from the <div> to the <form> tag (and the name which has been previously reported), which will cause "this" to refer to the div and not the form.


 Seth Cordes  Jun 24, 2015 
Other Digital Version Chapter 6
code scriptlet code for files

Code can be delete and the " files" variable can be defined in the code.gs file below the "folder" variable using the "folder" variable if you like.

Example:

var files =DriveApp.getFolderById(FOLDER_ID).getFiles();

In the index.html file, after <div id="options"> delete this code.

<?var files= Drive.getFolderBYId(FOLDER_ID).getFiles();?>


Best Regards :)

 Darryl Beauford  Sep 24, 2015 
Printed Page 10
1st Paragraph

The last sentence of the 1st Paragraph States:

Have a look at the Google Apps Script Example page (http://bit.ly/useful-lib/) for several helpful libraries.

When you goto http://bit.ly/useful-lib you end up at https://bitly.com/useful-lib/
Where it says:

Something's Wrong here..

Uh oh, bitly couldn't find a link for the bitly URL you clicked.
Most bitly URLs are 4-6 characters, and only include letters and numbers (and are case sensitive).

And I don't see any useful libraries.

 Anonymous  Oct 01, 2014 
11
The UiApp Service

function helloWorldUiApp() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var app = UiApp.createApplication().setTitle('Things'); //Replaced <Your Title> with 'Things'
app.add(app.createLabel('Hello World'));
//TODO add your code here
ss.show(app);
}

Result:

TypeError: Cannot call method "show" of null. (line 6, file "Code")

 Collin Lyle  Jul 17, 2017 
Printed Page 17
3rd Paragraph, Code

This code does not run, at least for me, and I've copied and pasted it from your shared google drive folder.

When you try to access the published web app url, you get:
Script function not found: doGet

Seems to run fine from development link, but not the live link. Is there some preliminary information missing?

 Anonymous  Aug 30, 2014 
Mobi Page 24
United States

Got an error when trying to run the following script:

function helloWorldUiApp() {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var app = UiApp.createApplication().setTitle(<Your Title>);
app.add(app.createLabel('Hello World'));
//TODO add your code here
ss.show(app);
}

Script UI error: ?Illegally formed XML syntax. (line 7, file "Code")?

Why is this error occurring?

 Richard Parkin  Aug 01, 2014 
Mobi Page 45
4th paragraph

Text says:

"Copy and paste the following buggy code into your ?Errors? script?s index.html file:"

Should instruct the reader that the code should be pasted into the Code.gs file instead.

 Richard Parkin  Aug 01, 2014 
PDF Page 46
Chapter 4: Adding Actions

Code provided is not working. After hitting subscribe button screen does not show Thank you message, it only goes blank. Java Console does not show any error. I'm using Chrome OS and version is updated. Version is: Versión 55.0.2883.105 (64-bit)
Plataforma 8872.76.0 (Official Build) stable-channel winky
Firmware Google_Winky.5216.265.53

Same Error reported by myself previously has wrong page number.

David Mencias  Jan 23, 2017 
Mobi Page 47
Code snippet in 3rd paragraph

Got error that html was undefined because replacement code snippet does not define var html before calling html.setContent().

 Richard Parkin  Aug 01, 2014 
Mobi Page 60
code sample

On page 60, the div id is set to "subscribe_form". Later examples, such as on page 64, do not set the div id but rather set a form id of "email_subscrible" and there is no further mention of the div id on page 60.

This inconsistency is confusing and should be explained or corrected.

 Richard Parkin  Aug 02, 2014 
PDF Page 60
code

Code provided is not working. After hitting subscribe button screen does not show Thank you message, it only goes blank. Java Console does not show any error. I'm using Chrome OS and version is updated. Version is: Versión 55.0.2883.105 (64-bit)
Plataforma 8872.76.0 (Official Build) stable-channel winky
Firmware Google_Winky.5216.265.53

 David Mencias  Jan 23, 2017 
Mobi Page 69
top code snippet

Code snippet reads:

src="//ajax.googleapis.com/ajax/libs/jquery/1.9.1/jquery

Missing closing quotation mark.

 Richard Parkin  Aug 01, 2014 
Printed Page 103
2nd Paragraph

Paragraph makes reference to the GUI Builder.

GUI Builder was deprecated in October 2013.

 Martin Bannister  Aug 25, 2014 
Printed Page 193
3rd line

Says: return uiApp;

Should say: return app;

Reason: in line 1 on pg. 193, var app = UiApp.....

"uiApp" is not defined, "app" is.

Otherwise the code worked great!

 Ryan Murphy  Aug 17, 2014