Auto-numbering

[Anish Reghu]

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]

Made a really quick test. Works instantly for insert. Obivously, this only covers inserts, not when someone is changing department.

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

	var prefixStr = 'BLM';
	var totalInt = 1000001;
	
	var ga = new GlideAggregate(current.getTableName());
	ga.addQuery('department', '8898b18a3b700300d901655593efc4aa');
	ga.addAggregate('COUNT');
	ga._query();

	if(ga._next()) {
		totalInt = totalInt + ga.getAggregate('COUNT');
	}
	
	current.user_name = prefixStr + totalInt;	

})(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

[Anish Reghu]

This works. Thank you, but can we code it to auto-number records of BLM users in a serial manner? I understand since you are appending the COUNT, it is numbering count value to the prefix.

I would prefer it to be this way:

Glide Record into the sys_user.

Query if it is department - X

If yes, save the record with auto-numbered user id.

While auto-numbering validate if the auto-number generated above is unique in the sys_user table.

Sorry for so much of trouble.

[Mark Roethof]

Obviously it depends on your way of working what error handling you need to build in, etc.. Or you might even need to store the number in a different table, like the auto number and then always just do +1 or something. Though it's really up to you.

This is just a basic example of what could work.

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

[Anish Reghu]

It works, I just created one more record and it takes the subsequent number. What puzzled me is the first auto-number generated through this ended with '12' instead of 1. 

[Mark Roethof]

Well it might be because there the count already results in 11 or 12, so that you already had 11 or 12 users with that department? Then for the first new user, it would indeed start with that instead of 1.

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