While creating table auto number prefix get dissapear how can i reset - Auto number ?

Pravin Yadav1
Tera Contributor

while already created a table form once its auto populated the prefix number but the tick box auto -number gets dissapear.

could anyone help..find_real_file.png

1 ACCEPTED SOLUTION

Community Alums
Not applicable

Hi @Pravin Yadav ,

To Add auto-numbering records in a table :

  1. Navigate to All > System Definition > Number Maintenance.
  2. Click a table name to view the number record for that table, or click New.
  3. Define the number format by completing the fields (see table).
  4. Click Submit or Update.
    If an auto-numbered field does not already exist, a new field is automatically created on the table with the following values:
    • Label: Number
    • Name: u_number
    • Default value:
      javascript:getNextObjNumberPadded();
      Note: This script renumbers records when the Number of digits is updated. To use a script that does not renumber records when the Number of digits is updated, open the dictionary entry for the Number field and enter the following script in the Default value field.
      javascript:getNextObjNumber();

    Read here.

     

    Mark my answer correct & Helpful, if Applicable.

    Thanks,
    Sandeep

 

View solution in original post

8 REPLIES 8

Community Alums
Not applicable

Hi @Pravin Yadav ,

To Add auto-numbering records in a table :

  1. Navigate to All > System Definition > Number Maintenance.
  2. Click a table name to view the number record for that table, or click New.
  3. Define the number format by completing the fields (see table).
  4. Click Submit or Update.
    If an auto-numbered field does not already exist, a new field is automatically created on the table with the following values:
    • Label: Number
    • Name: u_number
    • Default value:
      javascript:getNextObjNumberPadded();
      Note: This script renumbers records when the Number of digits is updated. To use a script that does not renumber records when the Number of digits is updated, open the dictionary entry for the Number field and enter the following script in the Default value field.
      javascript:getNextObjNumber();

    Read here.

     

    Mark my answer correct & Helpful, if Applicable.

    Thanks,
    Sandeep

 

Community Alums
Not applicable

Hi @Pravin Yadav ,

Glad to see my answer helped you, Kindly mark the answer as Correct & Helpful both such that others can get help.

Thanks,
Sandeep

Alok Das
Tera Guru

Hi Pravin,

 

You could refer to the below docs link:

https://docs.servicenow.com/en-US/bundle/sandiego-platform-administration/page/administer/field-admi...

Kindly mark my answer as Correct and Helpful based on the impact.

Regards,

Alok Das

Community Alums
Not applicable

Hi @Alok Das ,

I gave the same link in my answer.