• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Q&A

Q1:Is there a way to provide some kind of expert mode for validation?
A1: Validation rules are set in the Define Database dialog and apply to all users, so the basic answer is “no.” However, as with so many aspects of FileMaker, there's a relatively simple way of implementing this. You can create pairs of fields. Assign the validation rules to fields that you place in a layout for most people to use. In the companion field, use the auto-enter features to copy the value from the other field into the companion. If the validation rule fails (and the user cannot override it), there is no way of entering invalid data and thereby overriding the validation.

However, if you use the companion field on a layout only available to advanced users, they can modify the auto-entered value (if any). Because you don't place a validation rule on the companion field (which is the one you use in calculations and reports), people with access to the layout that allows entry into those fields—advanced users—can effectively override the validation rules that mere mortals cannot escape.

This architecture is common. You'll frequently find it useful to have both as-entered and as-used fields. Sometimes you use the reverse structure, allowing anything to be entered (without validations) and using a calculation to reformat or modify the raw data into the data that you will use.

Q2:What is the best way to test validation settings?
A2: Try entering some actual data with the settings. Particularly if you are using validation settings that don't allow overrides, make sure that you can enter all possible data. Look also at legacy data that needs to be converted or imported to make sure that it can pass the validation rules. You can bypass those rules, but remember that you can't rely on the data being valid.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint