Number Maintenance

hiroyasutakeda · ‎11-21-2017

Dear ServiceNow Developers

I made a custom incident table which was extended from the ServiceNow's default incident table.And as an index number of the incident report, I made a column "Call_ID" which is my custom column(please see picture 3), not a column of the default incident table. And I set the function "GetNextPaddedNumber" on this column so that "Call_ID" increases one by one automatically (please see picture 3). And I entered into the "Number Maintenance" page and register the record whose prefix is "V"(please see picture 4).

[My Question]

When I make an incident report, one report has two numbers of "Call_ID". One is in the field "Call_ID", the other is in the hader of a report(please see picture 1&2). I cannot understand the reason of the double counting(duplication) and I hope both numbers show same value.

What should I do? How can I change the header of the repor? Please show me the answer.

[picture1 : picture of incidents]

[picture2 : picture of the incident report "V0000000011"]

[picture3 : picture of the definition of the column "Call_ID"]

[picture4 : picture of the definition of the number maintenance "V"]

Best Regards, Hiroyasu Takeda

varads_kulkarni · ‎11-21-2017

Hi Hiroyasu,

Dont modify the dictionary for the Number. Keep it as it is with GetNextPaddedNumber.

Just Delete the Call_ID field.

And make sure you have an entry in Number Maintenance table for the new custom table that you have created with Prefix as V

After the above steps set the Number field as display on the new table.

View solution in original post

Kannan Nadar · ‎11-21-2017

Hello Hiroyasu,

From you picture 3 I can see that the Call ID field is not set as 'Display'. Please check the 'Display' checkbox and try again.

Thanks,

Kannan

hiroyasutakeda · ‎11-21-2017

Dear Kannan

Thank you for your answer. As you said, I checked the checkbox 'Display' of the column "Call_ID" definition. After that, the both numbers become same value. Please see the picture 5.

[picture5 : picture of the incident report "V0000000027"]

But the problem of the duplication still remains.

[picture6 : picture of incidents]

The Call_ID doesn't increase one by one.

Kannan Nadar · ‎11-21-2017

Hi,

Did you check out Varad's reply below, I believe that is the reason why your Call ID is not increasing one by one. Please check that.

Thanks,

Kannan

hiroyasutakeda · ‎11-22-2017

Dear Kannan

Thank you for your kind advices. I appreciated your reply.

The problem of duplication was resolved just few minutes before. Varad's advice helped me.

Thank you very much.

Best Regards, Hiroyasu Takeda