Help get this topic noticed by sharing it on Twitter, Facebook, or email.

FileMaker Pro 12 MM, page 107: Adding a Field Control Style

FileMaker Pro 12 Missing Manual, page 107: Adding a Field Control Style and a Value List. I am led to believe that the exercise will enable only pre-defined values to be entered in the field. Yet, I can enter any number I choose in in the Lease Duration field. Is that correct behavior?
1 person has
this question
+1
Reply
  • Hello John,

    Thank you for writing to us about FileMaker Pro 12: The Missing Manual.

    I'm sorry to hear you're having some confusion. I will refer your question to the book's authors.

    Nan
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated happy, confident, thankful, excited kidding, amused, unsure, silly indifferent, undecided, unconcerned

  • Hello John,

    Here is the answer to your question:

    Field controls, like drop-downs or pop-ups limit data entry, but don't absolutely enforce it. If you know how to click on the field to bypass the field control, you can do as you say -- type another value. To absolutely restrict data entry to one of the values in a value list, add validation to your field. That section starts on page 240. Validate the field as a "Member of a Value List."

    Hope this helps.

    Nan Barber
    Editor
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated happy, confident, thankful, excited kidding, amused, unsure, silly indifferent, undecided, unconcerned

  • Hi Nan,

    Thank you for your reply. I understand the behavior of the field control, just think the explanation on page 107 is a bit misleading:

    "ADDING A FIELD CONTROL STYLE AND A VALUE LIST
    Consistent data entry is critical to a well-behaved database. If you’re tracking students for your school district, and the best half of your data entry folks type a school’s name as “Glenwood Elementary School,” and the mediocre half type “Glenwood School,” and the lazy third half barely manage to peck out “Glnwod,” you’re going to have a mess on your hands. But you can control what users put into fields that should contain only specific bits of data. Figure 3-12 shows the Inspector’s Field panel, where you control how field’s look and behave."

    The fact is that a user *can* enter misspelled information, unless they are told to only use the drop-down menu. I know, it's just semantics. Anyhow the Missing Manuals are terrific and I'll continue to be an avid reader.

    John S
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated happy, confident, thankful, excited kidding, amused, unsure, silly indifferent, undecided, unconcerned

  • Hi John,

    Thank you for your good words about the Missing Manuals. I can see how the wording here was unclear, and we'll keep this in mind for the next edition.

    Nan Barber
    Editor
  • (some HTML allowed)
    How does this make you feel?
    Add Image
    I'm

    e.g. sad, anxious, confused, frustrated happy, confident, thankful, excited kidding, amused, unsure, silly indifferent, undecided, unconcerned