Alpha Video Training
Results 1 to 5 of 5

Thread: Is there a library of Validation formula?

  1. #1
    Member
    Real Name
    Bob Sisson
    Join Date
    Mar 2006
    Posts
    56

    Default Is there a library of Validation formula?

    I am sure that people have already written validations for a variety of fields.

    I am hoping that someone can point me at validation fields/formula/scripts for the following field types

    Phone Numbers
    Email Addresses
    Zip code
    Time (12:00am/pm)

    And many others I haven't even thought of yet...it would be nice if all of these were in a lib/help file/folder so novices like myself wouldn't have to recreate them...

  2. #2
    Member Beltronics's Avatar
    Real Name
    Jim Belanger
    Join Date
    Feb 2001
    Location
    Hollis NH
    Posts
    544

    Default

    I may be missing the point here but, if you go to Field Rules, you can select a "mask" for most common entries like you suggested and the user has to follow that mask when entering data.
    Jim Belanger

  3. #3
    Member
    Real Name
    Bob Sisson
    Join Date
    Mar 2006
    Posts
    56

    Default Having trouble getting there...

    I found what you were talking about in HELP...

    I am just having trouble navigating to that screen...

    For a beginer, there are LOTS of modes where you can see what you want to do but it won't let you...

    To me, it ALL should be in Field Properties, but that is not the case....

    I will try to figure out how to navigate to the screen that will let me enter a MASK not a validation...

  4. #4
    "Certified" Alphaholic Stan Mathews's Avatar
    Real Name
    Stan Mathews
    Join Date
    Apr 2000
    Location
    Bowling Green, KY
    Posts
    25,119

    Default

    Quote Originally Posted by rsisson
    I found what you were talking about in HELP...

    I am just having trouble navigating to that screen...

    For a beginer, there are LOTS of modes where you can see what you want to do but it won't let you...

    To me, it ALL should be in Field Properties, but that is not the case....

    I will try to figure out how to navigate to the screen that will let me enter a MASK not a validation...
    Try the documentation, mask - styles.

  5. #5
    Member Beltronics's Avatar
    Real Name
    Jim Belanger
    Join Date
    Feb 2001
    Location
    Hollis NH
    Posts
    544

    Default

    Go to the table you are working on in Control Panel. Click on "Design" then select "Field Rules". Navigate to the telephone field. Under the "data Entry" tab you will find "Mask" in the second choice down.
    Jim Belanger

Similar Threads

  1. formula help
    By urbanski in forum Alpha Five Version 6
    Replies: 14
    Last Post: 09-12-2005, 01:10 PM
  2. field look up formula
    By Ian_Edwards in forum Alpha Five Version 6
    Replies: 6
    Last Post: 08-21-2004, 10:52 AM
  3. formula help
    By John Burke in forum Alpha Five Version 5
    Replies: 5
    Last Post: 06-26-2004, 07:58 PM
  4. Formula Puzzle
    By Bill Feldhaus in forum Alpha Five Version 5
    Replies: 13
    Last Post: 11-13-2003, 07:24 AM
  5. field formula
    By Vincent Umali in forum Alpha Five Version 4
    Replies: 7
    Last Post: 05-13-2000, 07:51 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •