2 Replies Latest reply on Jun 17, 2013 10:46 AM by DanielHirner

    alphanumeric serial help

    DanielHirner

      Title

      alphanumeric serial help

      Post

           Hello,

           I'm very new (3days to be exact) to Filemaker and finding the experience fanstastic.  I'm building an app for FM Go for a client with my wildfire branch.  Each wildfire has a alphanumeric code (Fire Number) that I need to be conditionally validated...I think!.  Also as the user  is collecting data on a specific fire I would like them to enter the Fire Number once and then have that fire number be the default until they edit the value. i.e.  One Fire Number will have multiple records so I want the user to be able to enter the fire number and have that value carry forward to next records until the value of fire number is changed.  The Fire Number needs to be validated to meet the following criteria.  Any assistance would be most appreciated!

           Fire Numbers meet the following naming convention (CZnnnn eg. R10001) where:

             
      •           C = Fire Centre letter code           
                         
        •                     Kamloops - K
        •                
        •                     Prince George - G
        •                
        •                     Northwest - R
        •                
        •                     Southeast - N
        •                
        •                     Coastal – V
        •           
             
      •      
      •           Z = Fire Zone unit number (eg. A,B, 1, 2, 3, 4, 5, 6, 7, 8, 9).
      •      
      •           nnnn = Four-digit number from 0001 to 9999

            

      Thanks,
           Dan

        • 1. Re: alphanumeric serial help
          philmodjunk

               Patterncount ( "KGRNV" ; Left ( Self ; 1 ) ) and
               PatternCount ( "AB123456789" ; Middle ( self ; 2 ; 1 ) ) and
               GetAsNumber ( Middle ( self ; 3 ; 4 ) ) > 0 and
               GetAsNumber ( Middle ( self ; 3 ; 4 ) ) < 1000 And
               Length ( Self ) = 6

               Might serve as a custom validation calculation in field options.

               The rest of what you describe is a bit vague, but you can enter such a value ( or select it from a value list ) in a field with global storage and then this value will be retained no matter what record or layout you are on.

          • 2. Re: alphanumeric serial help
            DanielHirner

                 Thanks very much Phil.  This worked perfectly!


                 Dan