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

thirumala2 · ‎02-22-2022

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 ?

shloke04 · ‎02-23-2022

By mistake I have put a quotes while setting the value. You need to remove that:

Modified script below:

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

Try now should work.

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

Regards,
Shloke

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

Regards,
Shloke

View solution in original post

Prasad Pagar · ‎02-22-2022

Hi @thirumala

Did you tried any script already which is not working?

Thank you
Prasad

thirumala2 · ‎02-22-2022

Hi Prasad ,

Yes kind of which shloke added but no luck .

Prasad Pagar · ‎02-22-2022

Can you show your current script?

thirumala2 · ‎02-23-2022

ignore the inverted commas in current .number those I have removed .