hi,
i wanna copy URL of attachments into Incident Table field u_url.
My scripts not working....
BR Script: Table: incident before --insert/update
var producer_id = gel('sysparm_item_guid').value;
var gr = new GlideRecord('sys_attachment');
gr.addQuery('table_name', 'incident');
gr.addQuery('table_sys_id', producer_id);
gr.query();
if(gr.next())
{
current.u_url=gr.location.href;
}
Or-------------------------
BR Script: Table: sys_attachment before --insert/update
var grr=new GlideRecord('incident');
grr.addQuery('sys_id',current.table_sys_id);
grr.query();
if(grr.next)
{
var hrf=location.href;
grr.u_url=hrf;
grr.update();
}
1 ACCEPTED SOLUTION
