how to create 2 auto generate sequence number fields in single table?

[Purvi Kotadiya]

Requirement- I have a table 'test' and I would like to create 2 auto generate number fields. For ex: 1st-> test00001 (default)

2nd- > currentyear/01, currentyear/02 and so on should be auto generated based on certain conditions.

Can I have 2 number maintenance records for the same table as it doesn't have field name or any other approach?

[namanajain]

Hi @Purvi Kotadiya 
No — you cannot have 2 “Number Maintenance / auto-number” records for the same table to generate 2 different auto-numbers. ServiceNow table auto-numbering supports only ONE numbering scheme per table (it uses a single number_ref).

 

Solution:- If you need a 2nd auto-generated value (like YYYY/01, YYYY/02…), create it as a separate String field and populate it via a Business Rule / script (or use a separate counter logic per year).

Please mark this response as Helpful & Accept it as solution if it assisted you with your question.
Regards

 

[Purvi Kotadiya]

Hello @namanajain, thanks for the response. I was thinking of BR, but then will it be con currency safe?