I need to create a customer number that includes the year, and an accruing customer number.
E.g. 2020-0001, 2020-0002, etc.
The thing is, every year, the year has to change in the customer number, and the four numbers after it have to reset.
So if the last number of 2020 is 2020-1234, the first number of 2021 will be 2021-0001 again.
I can get the year from the Created Time field
The problem is the numbers after the year… I figure I can’t use an autonumber because it won’t reset each year.
I’m stuck on this part, and would appreciate any direction.