May 15, 20169 yr Trying to come up with a way to auto enter a serial number that resets each year. user enters in the a date field "production date" the year of that should prefix the serial number 161001 on average < 4000 records per year created Preferred not to be scripted and want it to auto increment on if record is duplicated. And not change if someone changes the production day (as long as its in the current year)
Create an account or sign in to comment