Generate codes for Tables.

[kpanchal]

Hello All,

I want to generate codes with all possible combinations of AA999. i.e If a user's name is Kathy Joe, 

The code should be generated as KJ980. I want to generate data to be filled in with Tables using background scripts. How can I achieve it.

PS: Code = First Name initial + Last Name initial + Combination of 3 numbers.

[Saurabh Gupta]

Hi,
You can create a custom table to generate sequential number automatically and append with the initials.

[Dr Atul G- LNG]

Hi @kpanchal 

Check this OOTB code on user Name Field

https://INSTANCENMAE.service-now.com/now/nav/ui/classic/params/target/sys_dictionary.do%3Fsysparm_query%3Dname%253dsys_user%255eelement%253dname%26sysparm_query_encoded%3Dname%253dsys_user%255eelement%253dname%26sysparm_referring_url%3Dsys_user.do%253fsys_id%253d62826bf03710200044e0bfc8bcbe5df1%254099%2540sysparm_record_rows%253d814%254099%2540sysparm_record_target%253dsys_user%254099%2540sysparm_record_list%253dORDERBYname%254099%2540sysparm_record_row%253d2%26sysparm_view%3Dadvanced%26sysparm_view_forced%3Dtrue

Take a base and use in background script.

[ersureshbe]

Hi,

Yes, use background script or fix script to achieve it. Define the custom table as mentioned below.

I believe you are going to apply this for the entire sys_user table.  Use active is true query it and define var x = 980 (Define it as per your wish)

Use charAt(0) for first_name & Last Name field.

Store it to the variable and amend with numberic i.e., x once provided the output you should increment it like x++ for next name and number definition.

var str = "HELLO WORLD";
str.charAt(0);// returns H