How to populate value in a field on approval table from workflow?

[thirumala2]

Hi ,

We have a requirement of populating value from workflow to a given field on approval table for managed docs .

From the below workflow run script :

@shloke04 can u help ?

[Prasad Pagar]

Remove the single quotes on line 14. It should be only current.number.toString();

[thirumala2]

That I already did still not working .

[shloke04]

Hi @thirumala 

You can use a Run Script activity in your Workflow assuming you have written your workflow on Managed Docs table and use the script below in your Run Script activity:

var gr = new GlideRecord('sysapproval_approver');
gr.addQuery('document_id',current.sys_id);
gr.query();
while(gr.next()){
gr.FIELDNAME = 'value which you want to set'; // Replace "FIELDNAME " with the one where you want to set on Approver table
gr.update();
}

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

[shloke04]

In case you want to set a value from Managed doc table and on to the Approver table then just use current and use the below modified script below:

var gr = new GlideRecord('sysapproval_approver');
gr.addQuery('document_id',current.sys_id);
gr.query();
while(gr.next()){
gr.FIELDNAME = 'current.FIELD Name of Managed Docs'; // Replace "FIELDNAME " with the one where you want to set on Approver table
gr.update();
}

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

[thirumala2]

Hi @shloke04 ,

Thanks for the response ,I have tried this I wanted to populate thedocument number on to that field on approval .But its not working .