AnsweredAssumed Answered

Unique Job Number Based on Date

Question asked by JamesKnecht on Apr 26, 2014
Latest reply on May 7, 2014 by JamesKnecht

Title

Unique Job Number Based on Date

Post

     Having trouble getting this to work.  I read some threads here, but they are fairly old.   Our dBase system generates a job number, during order entry, which is a unique 11 digit dumber based upon year, month, day + a 3 digit number.  First number of the day would be 20140426001.  The 3 digit number resets every day.  At worst case, I can use a simple auto entry serial number, set to be unique & not empty, but we are used to our numbers telling us when the job was entered.

      

     Any help would be appreciated & this will operate in a multi-user environment.  Please phrase your comments like you were talking to a child.  I am very new to Filemaker, but thanks to some help here, I have finished the customer file... and it is kick ass!

Outcomes