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).
Please let me know how to generate this unique job code. Thank you in advance for your help with this.