AnsweredAssumed Answered

Primary Key Serial Number Creation with Current Year as Prefix

Question asked by dennismoorejr on Mar 15, 2017
Latest reply on Mar 17, 2017 by philmodjunk

Hello all.


I am trying to accomplish the following;


Transaction Table


Field: __TransIDpk


I am trying to have the field Generate a serial number on create with the current year as the prefix to and incremental increase.


Example would be


2017_001 etc.


The idea is to have it reset after the new year automatically.


I was playing with the Get function without any success.


Thank you