2 Replies Latest reply on Jan 29, 2015 5:37 PM by DanielJenkins

    Validation Fields

    DanielJenkins

      Title

      Validation Fields

      Post

      I am new to using Filemaker pro.
      I'm creating a database in regards to a booking and invoicing system.
      How do I validate a Forename or Surname field, so that
      a) it changes the first letter to a capital automatically (i understand it uses proper or something?)
      b) ensure that only letters between a-z are entered? When i tick the range box and enter between A and Z, the custom error message is displayed even when the letters are between a-z for example, "Daniel"

      Thanks in advance,
      Daniel Jenkins

       

       

        • 1. Re: Validation Fields
          philmodjunk

          a) This is an auto-correction done via a calculation on the auto-enter tab.

          Upper ( Left ( self ) ; 1 ) & Right ( self ; Length ( self ) - 1 )

          Be sure to clear the "do not replace existing values" check box.

          You might see recommendations to use Proper ( self ), but this would turn McDaniels into Mcdaniels....

          b) What you tried didn't work because "A".."Z" and "a".."z" are two different ranges of values. You might choose to set up an auto-correct for this as well:

          Filter ( self ; "ABCDEFGHIJKLMNOPQRSTUVWXYZ" & Lower ( "ABCDEFGHIJKLMNOPQRSTUVWXYZ" ) )

          But this can also be set up as a validation calculation:

          Filter ( self ; "ABCDEFGHIJKLMNOPQRSTUVWXYZ" & Lower ( "ABCDEFGHIJKLMNOPQRSTUVWXYZ" ) ) = Self

          • 2. Re: Validation Fields
            DanielJenkins

            Thanks for the help, it is greatly appreciated! laugh
            Dan