Auto-numbering

Anish Reghu · ‎10-16-2020

If I add a new prefix - BLM on the sys_number table.

Now help me write a Business rule that this prefix will only auto-number user_name field on the User table if Department is BLM.

How to achieve this?

Mark Roethof · ‎10-17-2020

Maybe a small alternative, which would prevent issues when you are deleting users or removing the department of users: using an actual last number record.

- Just create a record in the sys_number_counter table (don't select a table, just create a record with only a number matching or higher then your last current number)

- Business Rule condition stays on department = your department OR department changes to your department, on insert + on update
Maybe add, user_name does not contain your prefix? But that's up to you.

- Script like (only update the sys_id with the sys_id of your new number record):

(function executeRule(current, previous /*null when async*/) {

	var prefixStr = 'BLM';
	var numberInt = 1000000;
	
	var grCounter = new GlideRecord('sys_number_counter');
	grCounter.get('be237ed32fb3d890b0c2d5ea2799b62a');
	
	var lastInt = grCounter.getValue('number');
	
	current.user_name = prefixStr + (parseInt(numberInt) + parseInt(lastInt) + 1);

	grCounter.addValue('number', 1);
	grCounter.update();
	
})(current, previous);

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020 ServiceNow Community MVP
2020 ServiceNow Developer MVP

---

LinkedIn
Community article list

Kind regards,

Mark Roethof

Independent ServiceNow Consultant

10x ServiceNow MVP

---

~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field

View solution in original post

Anish Reghu · ‎10-17-2020

** When I update a user record which has Department - BLM Market, no matter what User ID is (blank or a BLM ID), it generates the new user ID, it should not happen. It is because we have not validated any condition. I have added User ID does not contain BLM as a condition in "When to run" to avoid it. That fixed it.

** The other issue still exists. Can you help me check this?

How do I check if totalINT in the below line of code exists on the User ID field of user table or not?

Mark Roethof · ‎10-17-2020

"When I update a user record which has Department - BLM Market, no matter what User ID is (blank or a BLM ID), it generates the new user ID, it should not happen"

So did you add a condition on the Business Rule? Maybe you missed that part? I mentioned have added Department changes to <your-department>