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

 

Dennis

Outcomes