AnsweredAssumed Answered

alphanumeric serial help

Question asked by DanielHirner on Jun 13, 2013
Latest reply on Jun 17, 2013 by 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

Outcomes