AnsweredAssumed Answered

Job Code Creation

Question asked by mplutchok on Sep 23, 2015
Latest reply on Sep 25, 2015 by keywords

I'm relatively new to FileMaker and I am trying to generate an automatic job code, when a new record is created the job code should automatically be entered into the job code field. The format of the code would be:
Current Month/ Current Year/ Number - (Which starts at 001 and would reset and start at 001 at the beginning of each year).

Ex: 8/2015/007
       1/2016/001

Please let me know how to generate this unique job code. Thank you in advance for your help with this.

 

-Mike

 

Outcomes