How to create a one more number field for the incident table

Venky Kshatriy2
Tera Contributor

Present i am using the after BR 

(function executeRule(current, previous /*null when async*/) {
 
var RefNumber = "";
    var userGR = new GlideRecord('incident');
    userGR.addQuery('u_ref_no', 'STARTSWITH', 'GH');
    userGR.orderByDesc('u_ref_no');
    userGR.setLimit(1);
    userGR.query();
 
    if (userGR.next()) {
        RefNumber = userGR.getValue('u_ref_no');
        var numericPart = RefNumber.replace(/[^0-9]/g, '');
        //gs.addInfoMessage(numericPart);
        var nextNumericPart = parseInt(numericPart) + 1;
        //gs.addInfoMessage(nextNumericPart);
        var nextEmployeeNumber = "GH" + nextNumericPart;
        current.u_ref_no = nextEmployeeNumber;
        current.update();
    }
 
})(current, previous);
4 REPLIES 4

Anurag Tripathi
Mega Patron
Mega Patron

You can refer to this to learn how to create a number field. It doesn't require any scripting and you should use the Number Maintenance table

How To Create An Auto Number Field In ServiceNow - YouTube

 

But I'd like to ask what is the requirement here? What are you trying to achieve?

-Anurag

Already one number field is there need to create one more number field (REF no)

 

You can still use the number maintaincence

 

-Anurag

Ankur Bawiskar
Tera Patron
Tera Patron

@Venky Kshatriy2 

what's the business requirement to hold number?

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader