How to Auto-increement Asset Tag?

[Michelle Ricafr]

Hi,

1. I tried to follow steps on Add auto-numbering records in a table, added prefix (AST) and it worked. My first entry for example is AST0010001, on my 2nd entry the asset tag became AST0010003, 3rd entry AST0010005 and so on. The entry is not continuous as AST0010001, AST0010002, AST0010002 and so on.

2. Even I don't save the entry the auto-numbering continuous like that. So I tried the steps on Prevent numbering gaps after doing the steps, the Asset tag auto-numbering is not working, no data generated. After revert back steps on Prevent number gaps the asset tag worked again.

Please help.

Thanks,

Michelle

[Alikutty A]

Hello,

The Number field is by default created when you activate the auto numbering on a table. You will need to navigate to your table dictionary, Open the number column, remove its default value and deactivate the field. The default value for this field is performing an additional increment which is increasing the count by 2 every time you click on the New button giving you these results.

Please try it and let me know.

[Michelle Ricafr]

Hi,

If I will deactivate the field I will not able to see the result, after removing the default value no value generated for Asset tag field. Also the Asset Tag field is String Type.

Thanks,

Michelle

[Alikutty A]

Remove the default value from the Number field (u_number) and add this in the Default value for Asset Tag and it would generate you the required asset tag number without alternate gaps.

javascript:getNextObjNumberPadded();

[Michelle Ricafr]

Hi,

Asset tag is now generating value without alternate gaps.

When I create new records and do not save it, a gap in the numbering is created. I tried again the steps on preventing number gaps (https://docs.servicenow.com/bundle/jakarta-platform-administration/page/administer/field-administration/task/t_PreventNumberingGaps.html) but after doing the steps, the Asset tag auto-numbering is not working again, no value generated.

Thanks,