لطفا منتظر باشید ...
Validating by Number of Characters
Some data, like phone numbers or Social Security numbers, must always contain a fixed number of characters. But when users make simple errorslike adding hyphens in a phone numberthey often dont know that theyve done anything wrong. In the previous section, "Creating Field Masks," we showed you how to create a field mask to format a phone-number field. In order for the mask to work properly, the user must not enter more than 10 digits. This technique prevents such simple errors from taking place.
To validate by number of characters
1 .Open a file with a phone-number field whose length you want to limit.Well use the same file we worked with in "Creating Field Masks" (Figure 3.74).
Figure 3.74. Go to the layout whose phone number field you want to change.
[View full size image]
Figure 3.75. In the Validation panel of the Options dialog box, enter the maximum number of allowed characters.
Figure 3.76. Uncheck "Allow user to override during data entry" to prevent the user from ignoring the validation alert.
Figure 3.77. You can enter a custom message that displays if the user enters more than the specified number of characters.
Figure 3.78. If the validation fails, the user is prompted to change the input.
TipIf youve created a very clever FileMaker database, you may want to reuse it for other projects. If you choose File > Save a Copy As and choose Clone > No Data, youll have a fresh copy of your database that you can rename. If you copy that clone to the FileMaker templates Folder (in the same folder as the FileMaker application), it will show up in the templates list when you choose File > New Database.Keyboard Shortcuts
Many commands in FileMaker can be carried out without using a mouse. Here are some of the most useful.
