FileMaker Pro 11: The Missing Manual

Errata for FileMaker Pro 11: The Missing Manual

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

None  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 )

None  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:"

None  Jul 05, 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."

None  Jul 05, 2011  Oct 21, 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 
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 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."

None  Jul 07, 2011  Oct 21, 2011
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."

None  Dec 13, 2011 
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 
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 
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, PDF, Safari Books Online, 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
Stuart Gripman
O'Reilly Author 
Oct 13, 2011  Oct 21, 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 
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 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 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
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.

None  Jun 11, 2010