AnsweredAssumed Answered

creating a custom invoice/tracking number

Question asked by BenHerrera on Sep 18, 2013
Latest reply on Sep 18, 2013 by philmodjunk

Title

creating a custom invoice/tracking number

Post

     Hi all,

      

     I am new to FM. but savvy enough to break things and fix it. I just can't wrap my head around this... 

      

     I need to create a custom number for every new record... an internal tracking No. that needs to be formatted like:  

     yyyyabcd0000

     example:  2013OVB-1  

      

     there doesn't need to be a zero place holder preceding the "1".

      

     this number is going to be related to every record in the DB. There are 4 tables in the DB that will use this number. It will be unique to every record. regardless from which table the record is generated from, I need the number to be sequential?

      

     any thoughts

      

      

Outcomes