6 Replies Latest reply on Sep 3, 2009 6:51 AM by bestknownmethod

    Automated Serial/ID Creation

    bestknownmethod

      Title

      Automated Serial/ID Creation

      Post

      Good day!  I'm relatively new to FileMaker and I'm trying to create an Asset Inventory Database.  I did use the template and have since been going off on that to align all of our required fields in place.

       

      One thing I'm having a difficult doing is I'd like to create an automated serial ID when a new record is created based on the "Category" the asset falls under.

       

      Example:

       

      1) I create a new record

      2) I want an Inventory ID to be created once I select a Category Field to have a value of a "Desktop" with the Inventory ID to be called "DT-00001" and increment up as more are created under that category

      3) If I select "Laptop" from the Category Field value list, the first record will be called "LP-00001" and so on.

      4) I'd like for record to create the new Inventory ID upon a "Commit" or "Save button" as I have displayed...this I would like if possible

       

      I can get it to work this way:

      If ( Category = "Desktop"; SerialIncrement ( "DT-00000" ; 1)) 

       

      But I can't get it to work if I had another command such as "Laptop" etc.  I know there should be an easy way to do it, but I'm kind of lost.  Any help would be greatly appreciated.