Is there any way to copy the variables in a variable editor of a record to another new record?

Arsh1
Tera Contributor

So I am trying to create a copy of a record by clicking on a UI Action. Now the problem is I don't know that how I can copy the Variable editor data from that request to the copied request.

Any help would be appreciated 🙂

 

1 ACCEPTED SOLUTION

Hi,

this worked well for me

please enhance it further

var gr = new GlideRecord('incident');
gr.get('4dcd5214070b20102011ff208c1ed020'); // older record with variables

// create new record

var rec = new GlideRecord('incident');
rec.initialize();
rec.insert();

// then iterate for question_answer and insert the variable

var question = new GlideRecord('question_answer');
question.addQuery('table_sys_id', gr.sys_id);
question.query();
while(question.next()){

var att = new GlideRecord('question_answer');
att.initialize();
att.table_sys_id = rec.sys_id;
att.table_name = question.table_name;
att.question = question.question;
att.order = question.order;
att.value = question.value;
att.insert();
}

gs.info(rec.number);

Regards
Ankur

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

View solution in original post

14 REPLIES 14

Sure do ensure to close the thread by marking appropriate response as correct.

This helps for future readers.

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

Hey thanks it really worked.

But now a new problem is there. I Also need to copy the MRVS Data from one record to new record.

Is it possible?

Hi,

you need to insert data into this table which holds MRVS data

sc_multi_row_question_answer

Regards
Ankur

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

This worked GREAT for me, just wanted to say thank you!

si21
Tera Guru

Hi @Arsh1 / @Melisa Urbano , how did you make this code work. Has the variable editor copied to the new record? 

Could you please share complete Ui action code for cloning the record.

TIA