Validating Fields -- FileMaker Pro 11 Training 2-2

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
404 views
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Nov 8, 2011

The basics of FileMaker 11.

Your database solution would quickly fall to chaos if there were not some consistencies. FileMaker makes that easy with Field Validation.

FileMaker lets you test against certain criteria & will throw an error message if it does not pass!

There are many types of requirements FileMaker can impose on your solution's fields. You can have it check only when data is being entered, or always. The difference being, scripts and imports do not trigger when you choose to check during data entry.

FileMaker gives you the option of allowing your user to override the error message, as well as giving them a custom message of your choice.

Some of the requirements FileMaker can impose are:
Strict Data Type, Not Empty, Unique / Existing Value, Member of a value list, In a certain range of numbers, You can have it validate by running it through a calculation you write, or you can have it set to a max number of characters.

This is part eight in a very long training series, brought to you by LebonTech Solutions.

'We keep your data organized, so you don't have to'

Link to this comment:

Share to:
see all

All Comments (1)

Sign In or Sign Up now to post a comment!
  • nice!

    

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more