AnsweredAssumed Answered

How to generate an 8 digit ID number...

Question asked by jrobgk1 on Aug 2, 2011
Latest reply on Aug 2, 2011 by philmodjunk


How to generate an 8 digit ID number...


I would like to generate a unique 8 digit ID number that starts with a specific 4 number set (year of graduation, and in this example, field 1).  I would like the last four digits of the ID number generate automatically, from creation, in increments of 10 (field 2), so the final number would be 20160010, 20160020, etc.  or, {(field1,field2)}.

My first thought was to have two separate fields, then a concatenation field bringing the two results together, but I can't figure out how to force field two to be four digits in length...thoughts?