FileMaker Pro 12: The Missing Manual

Errata for FileMaker Pro 12: 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 2
NOTE

I've tried the link www.missingmanuals.com/cds/fmp12tmm (both with and without the "t" in the last bit since the "t" is missing from the URL on xxviii. All I get is a message that I've made an error

Note from the Author or Editor:
The link on page 2 should read: www.missingmanuals.com/cds/fmp12mm

Anonymous  May 29, 2013 
Printed
Page 49
Item 2 Last sentence. (2nd Printing)

"When it's done, you have all the ..." Should be " North Carolinians and Kentuckians in in found set. "

Note from the Author or Editor:
The last sentence under Step 2 on page 49 should read: "When it's done, you have all the North Carolinians and Kentuckians in one found set."

David J Kramer  Mar 26, 2013 
PDF
Page 767
Figure 18-16

The text above the figure says "To configure the backup location, in the admin console sidebar, choose database server. Then switch to the Folders tab. In the middle of this window, you see the backup folder location (Figure 18-16)." But the figure is incorrect. And I suspect that this figure is unintentionally swapped with figure 18-15.

Note from the Author or Editor:
Figure 18-15 should show the graphic that's shown in Figure 18-16 and vice versa.

James HO  Feb 25, 2013 
Printed
Page 752
Figure 18-6

I learnt many new words while studying this manual but cannot understand what do you mean by "... give a pew extra pixels of height to make sure data is legible." ? What does pew mean in this sentence?

Note from the Author or Editor:
Sorry about the typo James. That should be "a few extra pixels...."

James HO  Feb 23, 2013 
PDF
Page 405
2nd para

Missing close bracket for this code: Substitute ( Letter ; "for a limited time" ; TextStyleAdd ( "for a limited time" ; Bold+Italic )

Note from the Author or Editor:
The formula after the second bullet at the top of page 405 should read: Substitute ( Letter ; "for a limited time" ; TextStyleAdd ( "for a limited time" ; Bold+Italic ) )

James HO  Feb 15, 2013 
PDF
Page 389
NOTE

The NOTE box suggest the user to download the sample file for this chapter, called FunctionTypes.fp7, from this book’s Missing CD page at www.missingmanuals.com/cds/fmp12mm, however, I can't locate it and why are you asking us to use .fp7 when this book is on version 12? I can't find the file and could not figure it out the reason behind using .fp7....

Note from the Author or Editor:
The reference to the sample file used in this chapter should be "Ch10_Function_Types.fmp12."

James HO  Feb 13, 2013 
ePub
Page 415
United States

References to the missing cd are listed as follows: "Both are available on this book’s Missing CD page at www.missingmanuals.com/ fmp12mm." The actual address is "www.missingmanuals.com/cds/ fmp12mm." Prosser, Susan; Gripman, Stuart (2012-07-20). FileMaker Pro 12: The Missing Manual (p. 415). OReilly Media - A. Kindle Edition.

Note from the Author or Editor:
Please change the link to: http://missingmanuals.com/cds/fmp12mm/

Paul Schwartz  Nov 27, 2012  Dec 21, 2012
Printed
Page 441
Power Users' Clinic

Incorrect reference to page 466.

Note from the Author or Editor:
All page references will be fixed in the second printing.

Susan Murphy  Nov 25, 2012  Dec 21, 2012
Printed
Page 423
Up to Speed Box: Last paragraph

Page 734 doesn't describe the capture of script errors.

Note from the Author or Editor:
All page references will be corrected in the second printing.

Susan Murphy  Nov 25, 2012  Dec 21, 2012
Printed
Page 258
Up to Speed Box: Paragraphs 3 and 6

Pages 771 and 788 do not pertain to the Managed Container Storage subject of container location paths, and page 801 isn't on progressive backups.

Note from the Author or Editor:
All page references will be fixed in the second printing.

Susan Murphy  Nov 23, 2012  Dec 21, 2012
Printed
Page 385
NOTE

Page 154 isn't where mathematical operators are defined.

Note from the Author or Editor:
All page references will be fixed in the second printing.

Susan Murphy  Nov 23, 2012  Dec 21, 2012
Printed
Page 295
In "Repetitions" section, bottom of page, first paragraph, 1st sentence

"On page 238, you learned about repeating fields..." Page 238 discusses the entry of repetitive information, but not repeating fields.

Note from the Author or Editor:
All page references will be fixed in the second printing.

Susan E Murphy  Nov 23, 2012  Dec 21, 2012
Printed
Page 265
First sentence

Page 328 does not have an explanation of merge fields.

Note from the Author or Editor:
All page references will be fixed in the second printing.

Susan E Murphy  Nov 23, 2012  Dec 21, 2012
Printed
Page 249
Word to the Wise box: 2nd paragraph.

"...(she'd hook together two tables instead -- see page 163)." Page 163 doesn't help explain "hooking tables together".

Note from the Author or Editor:
All page references will be fixed in the second printing.

Susan E Murphy  Nov 23, 2012  Dec 21, 2012
Printed
Page 222
"Note" at top of page.

"...allow record creation (page 117) ..." page 117 doesn't describe the "allow record creation" option.

Note from the Author or Editor:
All page references will be fixed in the second printing.

Susan E Murphy  Nov 23, 2012  Dec 21, 2012
Printed
Page 577
Understanding Table Occurrences, 1st paragraph.

"page 133" has no discussion on the difference between tables and table occurrences. The "Note" on page 134 would be a better reference.

Note from the Author or Editor:
All page references will be fixed in the second printing.

Susan E Murphy  Nov 23, 2012  Dec 21, 2012
Printed
Page 188
Last paragraph, second sentence.

On entity without relationship: "Read back on page 175, and see if that item ought to be a field in one of the other tables." Section on page 175 begins the subject of entity selection, however it isn't until page 180 that ways to eliminate unnecessary entities is discussed.

Note from the Author or Editor:
All page references will be fixed in the second printing.

Susan E Murphy  Nov 23, 2012  Dec 21, 2012
Printed
Page 181
Up to Speed Box: Bullet 2

Page 626 does not explain table/file separation.

Note from the Author or Editor:
All page references will be fixed in the second printing.

Susan E Murphy  Nov 23, 2012  Dec 21, 2012
Printed
Page 140
Last two bullets in the box

Penultimate bullet references page 186 on "buttons"; page 186 doesn't have any button creation help. Last bullet reference on page 365 to "anchor" is incorrect.

Note from the Author or Editor:
All page references will be fixed in the second printing.

Susan E Murphy  Nov 23, 2012  Dec 21, 2012
Printed
Page 140
Up to Speed Box: Bullet 2

Page 504 doesn't have details on the filtering of portals.

Note from the Author or Editor:
All page references will be fixed in the second printing.

Susan E Murphy  Nov 23, 2012  Dec 21, 2012
Printed
Page 140
Up to Speed Box: first sentence.

Box is on page 140, and refers to a page later on in the book ---"On page 167, you learned about..." --- so the tense of this reference isn't logical; it is also incorrect, since page 167 doesn't deal with Portal Setup.

Note from the Author or Editor:
All page references will be fixed in the second printing.

Susan E Murphy  Nov 23, 2012  Dec 21, 2012
Printed
Page 128
Up to Speed Box: 5th Bullet, and 7th Bullet

5th Bullet: refers to box on page 113 that doesn't exist. 7th Bullet: refers to "key field... finer points on page 267." Page 267 doesn't describe anything about key fields.

Note from the Author or Editor:
All page references will be fixed in the second printing.

Susan E Murphy  Nov 23, 2012  Dec 21, 2012
PDF
Page 511
Figure 12-21

I do not think this is the correct screen shot for this Figure.

Note from the Author or Editor:
The incorrect figure will be replaced in the second printing.

Larry Schunk  Nov 14, 2012  Dec 21, 2012
PDF
Page 415
Figure 11-1 and text above the figure

This figure does not match the Sample START file as downloaded from www.missingmanuals.com/cds/fmp12mm. The book and Sample Files continue to not match. Please fix this.

Note from the Author or Editor:
We'll review the example files and revise as appropriate.

Larry Schunk  Nov 12, 2012  Dec 21, 2012
PDF
Page 380
The entire exercise

This entire exercise is meant to be completed by the reader. However, in the sample file downloaded from www.missingmanuals.com/cds/fmp12mm the entire exercise is already completed. It appears from this and previous errata submissions that a complete review of the sample files compared to the text is needed. It is extremely useful for the reader to actually compete the exercises, but they cannot if the samples already have them in completed for. ALL samples should include START and FINISHED files.

Note from the Author or Editor:
We'll review the example files and revise as appropriate.

Larry Schunk  Nov 08, 2012  Dec 21, 2012
PDF
Page 373
Last line on the page

The word "Contest" should be "Context"

Note from the Author or Editor:
Please change the last sentence on the page to read: (If your calculation doesn’t reference any related data, you can ignore the Context pop-up menu.)

Larry Schunk  Nov 08, 2012  Dec 21, 2012
PDF
Page 316
Last paragraph titled "Number Formatting

Paragraph says to go to the chapter's example file "CH08 People.fmp12" and go to the "Number Formatting layout". There is no "Number Formatting layout" in the example file.

Note from the Author or Editor:
Under the Number Formatting heading please change the first sentence to read: In this chapter’s example file, CH08 People.fmp12, go to the Data Formatting layout, select the Number Field and turn your attention to the Data Formatting section on the Inspector’s Data tab.

Larry Schunk  Nov 07, 2012  Dec 21, 2012
PDF
Page 314
Figure 8-6

In the Figure 8-6 The text accompanying the Figure is out of order. The first paragraph says "Top:", but it describes the "Middle" screen shot. In the second paragraph "middle" describes the "Top" screen shot.

Note from the Author or Editor:
In the caption for Figure 8-6, please swap the descriptions for Top and Middle.

Larry Schunk  Nov 07, 2012  Dec 21, 2012
PDF
Page 305
Step 5 in exercise

Step 5 says "In each of the Top, Bottom, Left, and Right text boxes, type 1. Don't forget the decimal point. On a Mac running OS X 10.8 Typing just 1. will not work, you must type 1.0 or 1.00. If you don't you will get an error dialog saying "The selected value must be in the range 0.000 to 10.000, inclusively"

Note from the Author or Editor:
Please change the first sentence of step 5 to read: In each of the Top, Bottom, Left, and Right text boxes, type 1.0.

Larry Schunk  Nov 07, 2012  Dec 21, 2012
PDF
Page 291
WARNING near bottom of page

This WARNING box states that the reader should "See the box on page 292 to learn how calculations can control these people's urge to get around the system." There is a box on page 292, but it does not address any sort of calculation for this VERY important issue.

Note from the Author or Editor:
All page references will be corrected in the second printing.

Larry Schunk  Nov 07, 2012  Dec 21, 2012
PDF
Page 283
Exercise

The the steps in this exercise have already been completed in the sample file downloaded from www.missingmanuals.com/cds/fmp12mm. This is confusing to the reader who is trying to follow along with the book and the opportunity to DO the exercise is lost. It appears that the Sample files available for download need a complete review.

Note from the Author or Editor:
We'll review the sample files and revise as appropriate.

Larry Schunk  Nov 07, 2012  Dec 21, 2012
PDF
Page 225
WARNING in middle of page

First sentence refers to Figure 5-25, I think it means to refer to Figure 5-23...

Note from the Author or Editor:
In the first sentence of the Warning sidebar, please change the reference from Figure 5-25 to Figure 5-23.

Larry Schunk  Nov 05, 2012  Dec 21, 2012
PDF
Page 211
POWER USERS' CLINIC at top of page

The POWER USERS' CLINIC box starts with a sentence that says "On page 238, you saw how to make Value Lists change..." However, if the reader is going through the manual from the beginning to the end as I think we should then we have not yet been to Page 238 and this is very confusing!

Note from the Author or Editor:
Please change the first sentence in the Power User's Clinic to read: On page 238, you'll see how to make value lists that change when you add, edit, or delete records in a table.

Larry Schunk  Nov 05, 2012  Dec 21, 2012
PDF
Page 154
In "POWER USERS' CLINIC" box last sentence in last paragraph

The sentence says "So once you've seen that {{CurrentDate}} makes a page number," {{CurrentDate}} makes the Current Date, not a page number.

Note from the Author or Editor:
Please change the last sentence of the Power User's Clinic to read: So once you’ve seen that {{CurrentDate}} shows today's date, forget about mousing around, and just type away.

Larry Schunk  Nov 05, 2012  Dec 21, 2012
PDF
Page 117
First paragraph below the "POWER USERS' CLINIC"

The last sentence in this paragraph says to use the "Space" button shown in Figure 3-17, but no "Space" button is evident in Figure 3-17.

Note from the Author or Editor:
Please change the reference from Figure 3-17 to Figure 3-18.

Larry Schunk  Nov 04, 2012  Dec 21, 2012
PDF
Page 103
Exercise at top of page

This exercise takes the reader through the process of inserting a picture (Logo) into the header of a FileMaker layout, however, in the sample file all of these steps have already ben performed and the Logo is already inserted into the proper place depriving the reader of the opportunity to follow along and properly complete the exercise. In previous sample file downloads it seems the was always a START file and a FINISHED file. The file provided here appears to be a "somewhere between START and FINISHED with much of the practice work already done. I think the entirety of the sample files for this book needs to be reviewed to ensure the proper files are provided. The sample files appear to have changed since they were originally published as I found a complete CD download that I downloaded shortly after the book was published that has many more files than the one currently on the web site, but still with omissions or other discrepancies. The earlier file for example seems to have .PDF files and .PNG files that are not present in the current download.

Note from the Author or Editor:
We'll review the example files and revise as appropriate.

Larry Schunk  Nov 04, 2012  Dec 21, 2012
PDF
Page 95
Figure 3-8

The Figure and all subsequent text describe changes the reader is supposed to make to the Sample file from www.missingmanuals.com/cds/fmp12mm, however the figures and text are not at all like the sample file provided. This makes it very difficult to follow along learning these fundamental concepts and skills. It seems that ALL of the sample files do not match the book very well at all. I have received updated files for Chapter 14, have all of the files been updated and not published?

Note from the Author or Editor:
Thanks. We'll review the example file in question.

Larry Schunk  Nov 04, 2012  Dec 21, 2012
PDF
Page 86
Note near top of page

The Note says that there are sample PDFs for download from the Missing CD pager at www.missingmanuals.com/cds/fmp12mm. This is not true as there are no PDFs available for download there.

Note from the Author or Editor:
An update will be posted shortly.

Larry Schunk  Nov 01, 2012  Dec 21, 2012
PDF
Page 84
Figure 3-3 text

The text accompanying Figure 3-3 states "manage the fields you're creating, and change the design of your data screen (page 71)." There is nothing pertaining to this on Page 71.

Note from the Author or Editor:
All page references will be fixed in the second printing.

Larry Schunk  Nov 01, 2012  Dec 21, 2012
PDF
Page 596
Note at bottom of page

The Note says that the file SW Zip Codes.fmp12 is included on the Missing CD available at www.missingmanuals.com/cds/fmp12mm. But as far as I can see that file is not there at all. Also, the files for Chapter 14 are not at all similar to what is described throughout the chapter. I found that I had to use the Chapter 17 files instead. On page 565 in the Note at the bottom of the page it says to use the files Invoices START.fmp12 and Invoices FINISHED.fmp12, but the only file in the Chapter 14 section of the Missing CD is Ch14_Invoices.fmp12. This is all very confusing.

Note from the Author or Editor:
Zip Code file is still missing at this writing. I've again submitted all three files: the Invoices START, Invoices FINISHED and SW Zip file. They should be uploaded soon.

Larry Schunk  Oct 30, 2012  Dec 21, 2012
Printed
Page 103
Item No. 1

The instruction on no. 1 refers to a graphic logo that should be available on the Missing Manual's Missing CD download. In reviewing the Missing CD downloads for the book, FileMaker Pro 12 the missing manual, there are no graphics files included for any of the chapters. The only files on the CD are the actual database files themselves and there appear to be no supporting files included.

Note from the Author or Editor:
I've just re-sent the graphics for that chapter to the editor. They should appear on the download site soon.

Rodrigo Perez  Oct 21, 2012  Dec 21, 2012
PDF
Page 616
Various

Page 616 and 618 present a duplicated section ... a FAQ titled "FileMaker's Web Browser".

Note from the Author or Editor:
The same sidebar appears on pages 617 and 618 of the PDF. To avoid throwing off page references, we'll leave them in place.

Charles South  Aug 07, 2012 
PDF
Page 204
Various

Arguably one of the most important aspects of working with FileMaker is to understand "context" ... what it means, where it is important, when it is applicable, how to change it, etc. The MM tries in multiple places to use (and quickly describe) this term while explaining some specific FileMaker concept, but as an experienced developer I find the recurring explanations at best misleading, at worst confusing, and sometimes inconsistent. Adding to the confusion is a lack of a specific definition accepted by everyone about the exact meaning of context in a database sense, which increases the importance of the MM using its own definition in a consistent and clear manner. Certainly context includes the "where" aspect (the active layout you are looking at or which the script has switched to) which in turn determines the specific Table Occurrence associated with that layout, which in turn determines what information is accessible to you through the Relationship Graph. This is the base level which every FileMaker developer must understand. If that's ALL you identify with "context" then it is critical to never confuse the reader by talking about a "Found Set" as if it were part of the context too. Or if you DO include the Current Found Set as part of your context, THEN you have to consistently include "which Window" is active in talking about context because the Found Set is unique to a Window and Layout combination (two windows can be looking at the same Layout but have different Found Sets). Too often I found the wording in the MM uncomfortable in seemingly implying that the Found Set was determined solely by knowing what the current Layout was. In the mentions of context in MM I only saw once the current Window mentioned as important to the Found Set, while MANY mentions of the Found Set seemed to say it was determined by the current Layout (without mentioning the Window dependency as well). Granted, in many solutions it is rare to have two windows open but it's crucial not to mislead the reader by oversimplifying how the Found Set is determined by Window and Layout (the latter determiningTable Occurrence). Then there are the subtleties of Sort-Order and whether you consider that is part of your current context (I don't). But because sort order is included so often in the MM when talking about Found Set, the reader can easily be mislead into thinking Sort Order is part of context if they didn't clearly understand whether Found Set was part of context (which it is, if you think about the general meaning of the word context outside the database world, meaning everything that affects what can happen next). It might help if the MM defined "context" in some more general sense important to database developers before moving to the Filemaker-specific concepts that explicitly determine context. My recommendation would be to put a full definition of context somewhere in the book, with repetitive references to that master definition when giving specific examples throughout the book. Because of the term's importance to FileMaker, I think there should be several pages devoted to this subject, with clarifying examples, perhaps in an appendix (because a new reader may not have the vocabulary or the concepts to fully understand the explanation if it occurred early in the book). This would allow short summaries to be embedded as necessary in various chapters, but still allow the reader to read the full explanation anytime they start to lose the full meaning of the word in a FileMaker sense. For that reason, the appendix would be most useful if it had back-pointers to the sections of the Missing Manual that best explain the crucial terms used in its own definition such as Table Occurrence, Layout, etc.

Note from the Author or Editor:
Thanks. We'll take your critique under advisement.

Charles South  Aug 07, 2012 
Printed
Page 104
Last two lines

"Chapter 311 gives details about all the Data tab's options..." Chapter 311 does not exist

Note from the Author or Editor:
Please change the last sentence on page 104 to read: Flip over to page 281 to learn more about the Data Tab's options, but you'll meet a few of them now.

Schuyler Johnson  Aug 06, 2012  Dec 21, 2012