How can I create and maintain an Automatic Number Control by content Type that needs to be restarted
Hi,
The customer wants an automatic numbering control by content type that needs to be restarted when the year changes.
I figured I'd create a table to control numbers with fields:
- Control_year = 2017;
- Control_TypeA = 00000;
- Control_TypeB = 00000;
- Control_TypeC = 00000;
If this New Check-in sequence occurs in 2017 (year):
1. first document of type A - AutoNumberFieldValue = 0001/2017 (Control_TypeA + 1, need to update Control_TypeA to 0001);
2. First document of type B - AutoNumberFieldValue = 0001/2017 (Control_TypeB + 1, need to update Control_TypeB to 0001);
3. second document type B - AutoNumberFieldValue = 0002/2017 (Control_TypeB + 1, need to update Control_TypeB to 0002);
4. First document of type C - AutoNumberFieldValue = 0001/2017 (Control_TypeC + 1, need to update the Control_TypeC to 0001);