glide created record and store field value in workflow scratchpad

Hitesh targe · ‎04-06-2018

Hi All,

How can we pass created record value into workflow scratch pad.

I am creating a record via catalog item workflow script and once the record is created, number will be auto generated in table.

I want to pass generated number into my same workflow scratch pad in next activity.

can anyone suggest me with the script please.

Thanks

Ashutosh Munot1 · ‎04-09-2018

HI,

This is the problem, You are trying to set reference field with String or Number value and that will not work here.

What should you do it save sys_id in scratchpad and use that to save it to u_position field. And That u_post table should have display value true for Number field. hence it will show number automatically there. Use below code:

var gr = new GlideRecord('u_posts');
gr.initialize();
gr.pos_desc = workflow.scratchpad.desc;
gr.pos_type = workflow.scratchpad.type;

var id = gr.insertWithReferences();

//var mem = new GlideRecord('u_posts');

//mem.addQuery('sys_id', id);

//mem.query();

//mem.next();

workflow.scratchpad.number = id;

And the use this scratchpad. This will show you record in this u_position field as this is a reference field.

Thanks,
Ashutosh Munot

View solution in original post

Ujjawal Vishnoi · ‎04-08-2018

ok then try this.

var gr = new GlideRecord('u_posts');
gr.newRecord();
gr.pos_desc = workflow.scratchpad.desc;
gr.pos_type = workflow.scratchpad.type;

var id = gr.insert();

workflow.scratchpad.number = gr.u_number;

Hitesh targe · ‎04-08-2018

HI Ujjawal,

Thanks for the reply. This is not working. The code which ashuthosh gave is working fine but the issue is, value is visble in list view. If I open the record, field is blank. please find my screenshots posted in my previous comment