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 |
| Other Digital Version |
16
People Database file |
It is not possible to sort by Status in the People database included for Chapter 1.
The reason appears to be because the Status field is set to be a number and (I'm not sure why yet) the system of sorting is only available for text fields.
Note from the Author or Editor:
I'll submit a revised sample file. |
Jon Anderson |
Nov 16, 2012 |
|
| Printed |
Page 163
Writing a Basic Script, Para 1, line 6 |
Should read "easier to sort the records"
i.e. missing "to"
Note from the Author or Editor:
On page 163, please change the third sentence under "Writing a Basic Script" from: "But it could be easier sort the records on the layout." to:
"But it could be easier to sort the records on the layout." |
Colin G.F. Brockie |
Apr 02, 2012 |
|
| Printed |
Page 51
Figure 2-1 |
The File Ch02_People downloaded form the website does not display in my application program as it is shown in the book. For example there are 29 records in it, many of which are duplicates. Also Figure 2-2 does not display right.
Note from the Author or Editor:
I'll update the sample file to better match the record count. |
Richard Rufer |
Mar 17, 2012 |
|
| Printed |
Page 197
5th bottom line |
The word 'in' appears to be missing from this line.
Note from the Author or Editor:
On page 197 in the last paragraph, please change the second sentence to read: "Read back on page 184 and see if that item ought to be a field in one of the other tables." |
Colin G.F. Brockie |
Mar 08, 2012 |
|
| PDF |
Page 485
First paragraph |
"To set this process up yourself, first create a Find Customers layout like the one shown in Figure 11-8."
Figure 11-8 shows a dialog box, not a layout. The reference should probably be to Figure 11-10.
Note from the Author or Editor:
The sentence should read:
"To set this process up yourself, first create a Find Customers layout like the one shown in Figure 11-10." |
RobJones |
Dec 13, 2011 |
|
| Printed |
Page 421
First line |
The text says
'10. In the Calculation box, type >0 (including the quotes) '
The quotes mentioned are missing. it should read
'10. In the Calculation box, type " >0 " (including the quotes) '
Note from the Author or Editor:
Please change the first line of page 421 to read:
10. In the Calculation box, type " >0 " (including the quotes) |
Mark Rogers |
Nov 14, 2011 |
|
| Printed |
Page 295
'Warning:' towards bottom of page |
Refers to a box on page 379 to learn how caluclations can control...
The box is actually 'One or Many' on page 299.
Note from the Author or Editor:
On page 295 in the Warning sidebar, please change the page reference to page 299. |
Mark Rogers |
Nov 11, 2011 |
|
| Printed |
Page 274
Sample database |
I downloaded the complete Missing CD .zip.
The example file for Chapter 7 is a 'finished' version - all the examples given in chapter 7 seem to have been completed. I've also downloaded the individual chapter .zip separately, but that is the same finished work.
For instance, on P287 / 288, it works through adding a Pop-up menu to the status field; indeed, bullet 3 on P288 says 'This window lists all the value lists you've created (you probably only have one right now)'. In fact, it comes pre populated with 4 value lists, including 'Status' which we are told to create.
Note from the Author or Editor:
I'll submit an updated example file. |
Mark Rogers |
Nov 11, 2011 |
|
| Printed |
Page 248
Between bullet points 2 & 3 |
I am using the Fields.FM7 file from your website for chapter 6.
There should be a bullet point after 2. that says 'Turn on the "Allow user to override during data entry"'.
In the sample file this box is not ticked by default, thus the resulting message in Figure 6-6 (p250) does not have a 'Yes' or 'No' button, and will not allow the customer to force entry of longer zip codes.
Note from the Author or Editor:
I'll provide an updated sample file. |
Mark Rogers |
Nov 10, 2011 |
|
| Printed, PDF, , Other Digital Version |
Page 525
Gem in the Rough box |
Please change the box title from "Gem in the Rough" to "Power Users' Clinic".
Thanks!
|
Stuart Gripman
|
Oct 13, 2011 |
Oct 21, 2011 |
| Printed |
Page 36
Caption on Fig 1-14. |
The quotation marks are ambiguous here.
The search term to enter is the two equal signs without the quotes.
Note from the Author or Editor:
On page 36 please change the third sentence of the figure 1-14 caption from:
In that case, you can enter "==" in a field.
to
In that case, you can enter == in a field. |
David Fink |
Sep 18, 2011 |
Oct 21, 2011 |
| Printed |
Page 25
At the end of "Editing a record" |
You state, "when you commit the record," but "commit" is not defined until the "Reverting a Record" section on page 26, in the Note and the "Up to Speed box." A "See page" cross-reference is needed here.
Note from the Author or Editor:
On page 25, please change the last sentence of the "Editing a record" section from:
(If you try this on the sample People.fp7 file provided on the Missing CD page, then you?ll notice that a field called Modified changes when you commit the record?s changes. You?ll learn what that field is used for later.)
To:
(If you try this on the sample People.fp7 file provided on the Missing CD page, then you?ll notice that a field called Modified changes when you click out of the record. You?ll learn what that field is used for later.) |
David Fink |
Sep 18, 2011 |
Oct 21, 2011 |
| Printed |
Page 6
6th bullet item, "Quick Find" paragraph |
The "Quick Find" paragraph is missing a word:
"will either a green"
should be
"will have either a green"
Note from the Author or Editor:
On page 6, please change the first sentence of the "Quick Find" bullet from:
? Quick Find fields (page 35) will either a green or yellow magnifying glass badge depending on the estimated speed that a find can be performed.
To:
? Quick Find fields (page 35) will have either a green or yellow magnifying glass badge depending on the estimated speed that a find can be performed. |
David Fink |
Sep 18, 2011 |
Oct 21, 2011 |
| Printed |
Page 702
6th paragraph |
The line "Code ( Get(TriggerKeystroke) ) > 32 or Code ( Get(TriggerKeystroke) ) ≠ 127" evaluates as TRUE for all Unicode code points smaller than 32 and the script will not work as intended.
Replace with "Code ( Get(TriggerKeystroke) ) > 32 and Code ( Get(TriggerKeystroke) ) ≠ 127"
The same mistake is repeated on page 703, Figure 16-16.
Note from the Author or Editor:
Please change as the reader indicated on pages 702 and 703.
The "≠" in his description should be an equals sign with a slash through it. That symbol appears correctly in the book and should not be changed. |
Thomas Seidl |
Sep 15, 2011 |
Oct 21, 2011 |
| Printed |
Page 495
3rd paragraph and Tip |
The Errata page contains two submissions for changing the term "OnLayoutLoad" to "OnLayoutEntry".
The first Note from the Author or Editor suggests replacing all occurrences of "OnLayoutLoad" with the new function name "OnLayoutEntry" on page 495. I believe the correct new function name should be "OnLayoutEnter" - not "OnLayoutEntry". Not counting the Tip section covered next, I only see one occurrence of this term.
The second Note from the Author or Editor says the term "OnLayoutLoad" appears as the second word of the first sentence and the second-to-last word on the last sentence. Again, the term only appears once in the Tip section - near the end of the last sentence. Unless any of the five instances of the term "OnRecordLoad" should be changed as well.
Note from the Author or Editor:
In older versions, the trigger was called "OnLayoutLoad." It's now called "OnLayoutEnter." |
steveald |
Aug 03, 2011 |
Oct 21, 2011 |
| Printed |
Page 126
"Making Two Layouts Match" |
The word "not" is missing.
"Although the text blocks and logos are now the same font and point size, you can see that they're in exactly the same spot."
You mean, I believe, that they're *not* in exactly the same spot--the next sentence details how to fix the mistake.
Note from the Author or Editor:
On page 126, please change the second sentence under the heading "Making Two Layouts Match" from "Although the text blocks and logos are now the same font and point size, you can see that they?re in exactly the same spot on the two layouts."
to
"Although the text blocks and logos are now the same font and point size, you can see that they?re not in exactly the same spot on the two layouts." |
Andrew |
Jul 10, 2011 |
Oct 21, 2011 |
| PDF |
Page 475
1st paragraph |
Current text:
Two script steps that let you switch to a different record. You can move switch with the ?Go to Record/Request/Page? script step, which works a lot like the Status toolbar?s book icon.
In the first sentence, "that" should be removed. In the second sentence, the word "move" should be removed.
Note from the Author or Editor:
Please replace the first paragraph of page 475 with the following:
"Two script steps that let you switch to a different record. The ?Go to Record/Request/Page? step works a lot like the Status toolbar?s book icon. Or you can switch to a related record, or a set of related records, using the ?Go to Related Record? script step." |
Joe Waters |
Jul 07, 2011 |
Oct 21, 2011 |
| PDF |
Page 417
In Figure 10-2 description text |
second step reads:
"...Find mode, put a find criteria in the Total Due field, ..."
In the picture and in the explanatory text it is the "Balance Due" field that is the focus of the find, not the "Total Due" field.
Note from the Author or Editor:
Please replace the existing Figure 10-2 caption with the following:
"This script tells File- Maker to switch to the Invoices with Balance Due layout, go to Find mode, put a find criteria in the Balance Due field, perform the find, and sort the found records. It may not use exactly the words you?d expect, but you can tell at a glance roughly what it does." |
Joe Waters |
Jul 05, 2011 |
Oct 21, 2011 |
| PDF |
Page 408
1st paragraph |
Sentence before bullets reads:
The answer is at the end of this section, but first you?ll learn the functions to you?ll need to calculate dates and times:
The "to" in the "functions to you'll need" should be removed.
Note from the Author or Editor:
Please change the 4th sentence under "Calculations that Create Dates and Times" from:
"The answer is at the end of this section, but first you?ll learn the functions to you?ll need to calculate dates and times:"
to
"The answer is at the end of this section, but first you?ll learn the functions you?ll need to calculate dates and times:" |
Joe Waters |
Jul 05, 2011 |
Oct 21, 2011 |
| PDF |
Page 399
Workaroud Workshop: When Data Doesn't Comply , Last line on left. |
The substitute example is shown as:
Substitute ( File Path ; "\ " ; "?" )
This is to replace the \ with a ?, but it won't work. The line should read:
Substitute ( File Path ; "\\" ; "?" )
Instead of a "\ " (downward slash and a space), you need two downward slashes, "\\".
This corrected version should also show in the final formula:
RightValues ( Substitute ( File Path ; "\\" ; "?" ) ; 1 )
Note from the Author or Editor:
This example was first written for a version of FMP that did not use backslash as an escape character.
Please change the line of code:
Substitute ( File Path ; "\ " ; "?" )
to
Substitute ( File Path ; "\\" ; "?" )
And the line of code
RightValues ( Substitute ( File Path ; "\ " ; "?" ) ; 1 )
to
RightValues ( Substitute ( File Path ; "\\" ; "?" ) ; 1 )
|
Joe Waters |
Jul 05, 2011 |
Oct 21, 2011 |
| PDF |
Page 397
FAQ - The Middle Way |
Current text:
------
For example, you can use Left() and Right() instead of Middle() if you want. This calculation:
Middle ( Product Number ; 4 ; 3 )
can be rewritten like this:
Right ( Left ( Product Number ; 7 ) ; 3 )
--------
The two formulas do not produce the same result. The first one extracts the 4th, 5th, and 6th character while the second formula extracts the 5th, 6th, and 7th character. To correct, change the "7" in the second formula to be a "6".
Note from the Author or Editor:
In the box titled "The Middle Way" on page 397 of the PDF eBook:
Please change the line of code that reads:
Right ( Left ( Product Number ; 7 ) ; 3 )
to
Right ( Left ( Product Number ; 6 ) ; 3 ) |
Joe Waters |
Jul 05, 2011 |
Oct 21, 2011 |
| Printed |
Page 205
4th line (bullet point) |
Line instructs to create relationship "Invoice Payments::Invoice ID to Invoice ID".
I presume that the "TO" table being referred to by the second "Invoice ID" reference is on the Invoice table, but that information is omitted.
Note from the Author or Editor:
On page 205 of the printed version, please change the fourth bullet point down to read "Invoice Payments::Invoice ID to Invoices::Invoice ID". |
Leslie D. Martin |
Jun 14, 2011 |
Oct 21, 2011 |
| Printed |
Page 92
UP TO SPEED |
"When you're deciding what fields to put in your database,
it helps to imagine, or a spreadsheet."
Note from the Author or Editor:
phrase should read: "it helps to imagine a table, or a spreadsheet." |
Michael Maclaga |
Jun 08, 2011 |
Oct 21, 2011 |
| Printed |
Page 699
'Note:' section |
commas used - should be semicolons.
Note from the Author or Editor:
The note section should read:
If ( Get (TriggerKeystroke) = ?a?; ?Yes?; ?No?)
You can do this:
If ( Exact ( Get(TriggerKeystroke), ?a?); ?Yes?; ?No?)
|
Joseph Azzarelli |
May 28, 2011 |
Oct 21, 2011 |
| Printed |
Page 663
End of the "Nesting Let Functions" paragraph |
The syntax of the first argument to the Let function invocation is incorrect. Specifically, it is missing the square brackets. It currently reads:
Let ( X = 3; Y = 4 ; X * Y )
It should be:
Let ( [ X = 3; Y = 4 ] ; X * Y )
Note from the Author or Editor:
the Let statement should read:
Let ( [ X = 3 ; Y = 4 ] ; X * Y ) |
Jim Silverman |
Mar 26, 2011 |
Oct 21, 2011 |
| Printed |
Page 96
2nd p |
It seems that the command Insert->Quicktime with pdf files only works on MacOS
I'm working with Win7 and FM11pro and always get an error message when trying to import a pdf file.
Note from the Author or Editor:
Note: Inserting pdf files as QuickTime so you can use the player is a Mac-only feature. |
Ekke Wegscheider |
Jan 25, 2011 |
|
| PDF |
Page 640
Step 15 |
Step 15 should be eliminated. If being performed, the chart shows nothing.
Note from the Author or Editor:
Please delete step 15 and decrement the remaining step numbers by one. |
Yinyu Tu |
Oct 14, 2010 |
|
| PDF |
Page 495
Tip |
use OnLayoutLoad instead
should be
use OnLayoutEntry instead
Note from the Author or Editor:
Please replace the term "OnLayoutLoad" with "OnLayoutEnter" in the tip on page 495. It appears as the second word of the first sentence and the second-to-last word on the last sentence. |
Yinyu |
Oct 02, 2010 |
|
| PDF |
Page 461
1st paragraph |
you can specify a target field so that FileMaker operates on the current field
should be
so that FileMaker operates on the correct field
Note from the Author or Editor:
Please change p461, paragraph 1, sentence 5 from:
"First, you can specify a target field so that FileMaker operates on the current field."
To:
"First, you specify a target field so that FileMaker knows where to find the text to select. |
Yinyu Tu |
Oct 02, 2010 |
|
| PDF |
Page 495
3rd Paragrah |
If you do a find on theis layout when the OnLayoutLoad trigger is set,
should be
If you do a find on theis layout when the OnLayoutentry trigger is set,
Note from the Author or Editor:
Please replace all occurrences of "OnLayoutLoad" with the new function name "OnLayoutEntry"on page 495. |
Yinyu Tu |
Oct 02, 2010 |
|
| Printed |
Page 25
NOTE |
"See page 158 for details." should read: "See pp 322-323 for details"
The indexer has confused two kinds of tabs. Pages 25 and 322 are concerned with tabbing between fields. Page 158 is about tabs of the kind that protude from a fie folder in order to carry a label.
Note from the Author or Editor:
In the note on page 25, please change "See page 158 for details." to "See page322 for details." |
Michael Howe-Smith |
Sep 22, 2010 |
|
| Printed |
Page 66
Task 2 |
In the supplied data downloaded from the web site in support of this book, there are no "Vocalists" in that data. This means that this 'find' does not work
Note from the Author or Editor:
I'll submit a revised example file for TMCD. |
SD1820 |
Sep 22, 2010 |
|
| Printed |
Page 56
Task 4 |
The example data downloaded from the Web site to support the exercises, contains very few records. There are no records that have a NY State field, hence when you perform the 'Find', no records are found.
Note from the Author or Editor:
I'll submit a revised example file for TMCD. |
SD1820 |
Sep 22, 2010 |
|
| Printed |
Page 121
Figure 3-13 |
The lines in this diagram, to show where the "Bottom Border" and "Right Border" buttons are located (in the Inspector's Appearance->Object panel), are reversed. The labels "Bottom" and "Right" should be swapped to correct the figure.
Note from the Author or Editor:
The labels "Bottom" and "Right" should be swapped to correct the figure. |
BrannonSG |
Aug 17, 2010 |
Oct 21, 2011 |
| PDF |
Page 64
one line above the last paragraph |
Original
smith# matches ?smith1? and ?smith42? but not ?smithy?
I tested the above statement and it turned out
smith# only found smith1
smith## only found smith42
Note from the Author or Editor:
On page 64 (print & PDF versions), please change:
smith# matches ?smith1? and ?smith42? but not ?smithy?
to
smith# matches ?smith1? but not ?smith42? or ?smithy? |
Yinyu Tu |
Aug 13, 2010 |
|
| Printed |
Page 40
Last paragraph on page 40. |
A minor 'point' perhaps, but the period is missing at the end of the last sentence on page 40.
Note from the Author or Editor:
Yep. It's not there. |
Steve Brannon |
Jul 27, 2010 |
|
| PDF |
Page 12
3rd paragraph |
There is no ?Sign Up for Our Newsletter? link in the TheMissingManual.com website.
Note from the Author or Editor:
FileMaker tells me that they've removed the newsletter temporarily and will let me know when it starts up again. I'll post a revised link when I one. |
Anonymous |
Jun 28, 2010 |
|
| PDF |
Page 860
3rd graph under Paid support |
The link to FileMaker's File Recovery Service does not work. This link should be substituted: http://help.filemaker.com/app/answers/detail/a_id/1633/kw/file%20recovery/session/L3NpZC9oRE9HazUyaw%3D%3D
Note from the Author or Editor:
The new link should be used. |
karenshaner |
Jun 11, 2010 |
|