Two number maintenance for one single table/form in servicenow.

[VikramM1]

Is there any possibility to create two number maintenance auto numbering for a single table or  form.

I created one number maintenance like DNC-00001, I want this create one more like D-0001.

If not possible with number main any other suggestions or code that any one can share that will be helpful.

[johnfeist]

Hi VIkramM1,

If the new number is simply an extraction from the existing one, you can add that field onto your record and then create a before insert business rule.  In it you just need a statement something like this:

current.otherNumber = <prefix> + current.number.substring(x,y);

where <prefix is D- or whatever and x,y are start and length.

Make sure that you don't include an update() statement in any before insert rule or you could end up in an endless loop.

If you need to use some other sequential mechanism, the simplest thing is to create a property and start it with zero.  Then your before insert rule can look up the value, increment it for attaching to the alternative number field and also update the property.

[Dr Atul G- LNG]

Hi @VikramM1 

Any reason to have 2 different numbers for the same form? It is not  a recommended approach.

[Sohail Khilji]

Hi @VikramM1 ,

Yes ! but techenically not good unless you can manage it well ! 

The way to do is by creating 2 diffrent numbering field on 1 table with Prex as DNC-00001 and D-0001 instead of 1 field. (the possible solution is by using 2 field not by 1 field)

Based on your conditon you can set the UI POLICY visiblity of each field. I hope this helps...