Auto Numbering for extensible table

rev3 · ‎08-22-2016

Hello community,

I have an OOB table which is extensible. I am trying to enable Auto numbering for this OOB table using Managing Record Numbering - ServiceNow Wiki . The list view shows all the records from the child tables as well.

When i setup auto numbering for this table, it is applied to the records which extended from this table. Can we avoid this to happen?

I want to auto number only the records of that table but not child table records.

Thank You

Reva

jake_mckenna · ‎08-22-2016

To prevent number gaps there is a property to set here: Managing Record Numbering - ServiceNow Wiki by setting Assign a task number only upon insert (prevents unused numbers) to true

I believe it is not an attribute, but would simply be setting an override to say default value = '' on the child tables. In most cases this field should be populated and what I would also recommend is setting a net Number maintenance on the child tables to track a different set of numbers to manage each table.

View solution in original post

odijk · ‎08-22-2016

The idea of a Dictionary Override is that the Child will have a different behavior than the Parent.

There is a related list with the Dictionary Overrides; Here you can select a Child table and then set the behavior specifically for that table. (in your case: select the tick-box with the Default Value). Please read the link that Jake provided about the Dictionary Overrides carefully, especially paragraph 3: Defining Dictionary Overrides

rev3 · ‎08-22-2016

Thank You Martijn,

I wasn't focusing properly. Thank You for directing.

Thanks again,

Reva

rev3 · ‎08-22-2016

Thank You Jake that trick worked.

Thanks much !!

Reva

Suresh1 · ‎08-22-2016

Hi Reva,

In the 'number' field-->personalize dictionary, remove the "default value" of "Get Next Number Padded", Instead you can write a Business rule so that once the record is created, the number will gets auto populated with auto numbering.

odijk · ‎08-22-2016

I think there are two solutions for this:

1) create an alternative autonumerical for the extended table. (as an example: look at the autonumerical setup for Incidents, that override the autonumerical setup of the Task table. url: <your_instance>.service-now.com/sys_number_list.do?sysparm_query=category%3Dtask%5EORcategory%3Dincident

2) The solution that Jake provided: Override the Default Value, as that is used to actually set the number.

(please be aware that the property "Assign a task number only upon insert (prevents unused numbers)" means that the field is only set after the record is saved. This is obvious, but it means for instance that a ServiceDesk agent can only provide the Incident or Call number to a client after saving the record.)