AnsweredAssumed Answered

Asset Code based on fields and serial

Question asked by AmjadMiandad on Jul 31, 2013
Latest reply on Aug 19, 2013 by philmodjunk

Title

Asset Code based on fields and serial

Post

     Hi friends,

      

     I'm working on a database for our Asset management. Below please have a look on fields and sample data

      

     Asset Code: ---------------

     Asset Name: Laptop

     Asset Type: computers

     Asset Model: Insprion N5050

     Asset Category: IT Equipments

     Project: School Safety Program

     Donor: My Donor Pvt. Ltd.

     Now what we want is the auto asset code to be created using abbreviation from the data of some fields and at the end auto number 0001 , 0002 , 0003, 0004, 0005 (separate series for every Asset Type, i.e. laptops, scanners, etc)

     ABCD/PROJECT/DONOR/ASSET CATEGORY/ASSET NAME/0001

     Now have a look on actual asset code so you may understand what sort of abbrevation I taken from the data mentioned in above fields.

     ABCD/SSP/MAYDONOR/ITEQ/LAPT/0001

     The abbreviation could be random pick from entered data in the field with any calculation.

     Please note that ABCD will remain constant in my case it is RDPI/  Projects short name / donors major or short name or abbreviation/ four alphabates from item category /four alphabates from item name/serial number

      

      

     Thanks.

Outcomes