When using "Get Next Padded Number" in an application table i am getting an error like invalid update.

[Sandeep132]

In an application table when i am entering "Get Next Padded Number" into default value in dictionary for a number field i am getting an error like "Invalid Update reset to original".

Please let me know how to use the auto increment feature for a number in application table.

Title edited by: Madhuri Gudiseva

[gowriseshasalam]

either you can set auto increment field as true for that table or Right click on the label ->configure dictionary in that advance view default value tab select use dynamic default and below that you may see the dynamic default value that is reference to dynamic filter options select the GetNextPaddedNumber and update.

I think it will work

[nishant8051]

what is the use of getnextPaddednumber??

[Bhushan216]

Hello Nishant,

Exact use of "getnextPaddednumber" is for maintaining the autonumbering present OOB for newly created record for tried to explain it in more depth in below example. 

Case #1 - If getnextPaddednumber is not used records can have random number for example incident which is created now may have number 1001 and next one can exist with 1003 which means we missed 1002 somehow here.

Case #2 - If we have Implemented getnextPaddednumber  sequence of auto numbering is maintained which you can check in ServiceNow table "sys_number_counter.LIST".

Attaching ServiceNow Document Link for any reference.

Please mark Helpful if it helps you to understand.

Thank you,

Bhushan

[VenkataAnand7]

I added next padded number for my admission field bu it is auto incrementing by 2 values every time why this happen