Need to populate the free text value to the one of the reference field in the Incident table

[vinuth v]

Hi All,

I am working on the Record producer form, My requirement is on the form level I have one field called "Please provide the ADO/Change number associated with the previous change." it is a single line text field and I wanted to updated this field value to the "Caused by Change" OOB field in the incident table and it is a reference field and referring to change_request table.

Note : 

Please provide the ADO/Change number associated with the previous change backend value is ado_change

Caused by Change backend value is caused_by

I tried like this in the Record Producer script,

In the background script I tried like below,

var gr=new GlideRecord("incident");

gr.addQuery('number', 'INC0010003');

gr.query();

if(gr.next())

{

    gr.caused_by="chg3344";

    gr.update();

}

But It is not working please any one suggest me,

Thanks,

Vinuth

[NitishKumar0012]

var gr=new GlideRecord("change_request");

gr.addQuery('number', producer.ado_change);

gr.query();

if(gr.next())

{

    current.caused_by=gr.sys_id;

}

[vinuth v]

Hi @NitishKumar0012 

I tried above one but it is not working,