Auto generate ID with numbering startig from 101, 102, 103

[Rachel39]

Hi Experts,

I have a custom table name u_org_hierarchy with columns having ID, Name etc.
Requirement: Auto generate the ID field whenever a new record is inserted in the table u_org_hierarchy and if the last record is 105 so the new record should be generated as 106 in ID field.
Could you please help me achieve this by business rule.

Checkout the screenshot, ID field should be generated as starting with 101 and next record should be 102

[Samaksh Wani · Accepted solution]

Hello @Rachel39 

Go to Table > you can check for related tab and refer below screenshot

Give prefix, number and number of digits as per your requirement.

Plz Mark my Solution as Accept and Give me thumbs up, if you find it Helpful.

Regards,

Samaksh

[Samaksh Wani · Accepted solution]

Hello @Rachel39 

Go to Table > you can check for related tab and refer below screenshot

Give prefix, number and number of digits as per your requirement.

Plz Mark my Solution as Accept and Give me thumbs up, if you find it Helpful.

Regards,

Samaksh

[Rachel39]

There is no option 'Controls' in dictionary for ID field.
Can we have the solutioning via business rule?

[Samaksh Wani]

Hello @Rachel39 

Type Tables in navigator and open the records of table.

Search with your table name and open it. You will then find this options in related tabs

[Kalyani Jangam1 · Accepted solution]

Hi @Rachel39 

There is Number Maintenance table in servicenow in which it is autopopulate number in field. You can check once for your table like below

It is possible using business rule but in business rule it is not displayed when form load it will update once record insert.