Script to copy the value of a field to another field in the same table

[carlh]

Hi All,

I am doing some clean up and need help.   I extended the CMDB_CI table and added a class called "Mobile Devices" for our phones and tablets but I didn't use the "NAME" field and now I can't see them from the reference field on my incident form.

Could someone share a script that will do the following?:

Table "u_mobiles devices"

If "u_imei_string" is not empty, copy the value in to the "name" field.

I plan to put a business rule in place to copy this in the future or I can just add the name field to the form.

Please let me know thoughts and if you are willing to share a script.

Thank you

Carl

[Justin Abbott · Accepted solution]

var gr = new GlideRecord('u_mobiles_devices');
gr.query();
while (gr.next()) {
   var x = gr.getValue('u_imei_string');
   if (x) {
           gr.setValue('name', x);
           gr.update();
   }
}

You could run that as a background script.

[carlh]

Thank you Justin.   It worked great!

[Joe DeStefano2]

That works beautifully!

[SanjivMeher]

Hi Carl,

Add a before insert/update business rule on Table "u_mobiles devices"

if (current.u_imei_string!='')

{

        current.name = current.u_imei_string;

}