To copy variable's value into a journal type field

Poorva Bhawsar
Mega Sage

‎01-18-2024 10:52 PM

Hi Community,

 

I have few select box variables, if user selects the value of those variables as rejected, rejection reason field will populate. I want to copy the value of those variables if they are rejected along with the rejection reason from sctask to another table's journal type field.

 

I am thinking about the logic like if xyz == rejected && rejection reason != '' then need to add them in that journal field. If those are not rejected, those i approved i dont want to add them in this journal field.

 

Thanks,

Poorva Bhawsar

 

0 Helpfuls

Harish KM
Kilo Patron

‎01-18-2024 11:03 PM

Hi @Poorva Bhawsar you can do like you said, to check the value of variable in BR you can do like this

if(current.variables.xyz == 'rejected' && current.rejection_reason !='')

{

//glide another table to pass the values to journal field.

}

 

Regards
Harish
0 Helpfuls

Poorva Bhawsar
Mega Sage
In response to Harish KM

‎01-19-2024 01:37 AM

This logic i already told but how to pass those values that i need.

0 Helpfuls

Harish KM
Kilo Patron
In response to Poorva Bhawsar

‎01-19-2024 01:54 AM

Hi @Poorva Bhawsar  assuming your BR is on sc task table with before update checked

sample script:

if(current.variables.xyz == 'rejected' && current.rejection_reason !='')

{

var gr = new GlideRecord('tablename');

gr.addQuery('parent',current.sys_id); // parent is the field on the table which holds reference to sc task table

gr.query();

if(gr.next())

{

gr.comments = "Rejected Reason :"+current.variables.variablename +'<br>'+ "Reason": +current.fieldname;

}

 

}

Regards
Harish
0 Helpfuls

Poorva Bhawsar
Mega Sage
In response to Harish KM

‎01-19-2024 02:09 AM

I have multiple variables. Do i need to gliderecord for all or i need to loop for that?

0 Helpfuls