Copy custom variable in record producer to OOTB record producer attachment

[ronro2]

Hey! 

In a record producer I have a custom variable of type attachment called 'bifoga_fil':

So I want to copy this to the OOTB attachment on the record producer in the back-end, so that the attachment is visible in the banner above and in the logs. 

I've marked what I mean with red. 

So, I am thinking an after insert business rule of some kind? What would that look like? 

I'm thankful for your help. 

All good, 

[ronro2]

@Ankur Bawiskar the issue is that it doesn't show in the background as an attachment in the logs and in the banner above. Because it is not mapped to the OOTB sys_attachment? I guess. 

Or am I missing your point? 

[Ankur Bawiskar]

@ronro2 

yes you missed my point

1) have attachment variable and make it mandatory based on your condition

2) then use this script in record producer script and then that file attached on variable will be copied to the target record on record header

new global.VariableUtil().copyAttachment(producer.<variableName>,'<tableName>', current.sys_id);

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Ankur Bawiskar]

@ronro2 

Any update to above?

I already shared a working solution

[Rakesh_M]

Hi @ronro2 ,
Add the following script to script field of record producer

var attach_sysid = producer.bifoga_fil; //variable_name

if (attach_sysid) {
    var gr = new GlideRecord("sys_attachment");
    if (gr.get(attach_sysid)) {
        gr.table_sys_id = current.sys_id;  
        gr.table_name = "incident";   //replace with table name
        gr.update();
    }
}

[ronro2]

@Rakesh_M so, I get this error message when I submit the form with an attachment: 

'Write operation against 'sys_attachment' from scope 'x_vgll_rail' has been refused due to the table's cross-scope access policy'. 

So they are in different scopes, is there a way to work through this in the script? To get cross scope access?