How to copy List field value from one table to a string field of another table

[Samiksha2]

Hi,

I have created a list field(BU with options a,b,c,d) in the sn_gf_goal_target table. 

and another string field(Selected BU) in the sn_gf_goal table. 

I want to copy the value of List from the Target table to Goal table.

Suppose Goal table has 3 Target records(1,2,3), and 

1 is selected a,b 

2 is selected c,d

3 is selected a,d.

Then in the selected BU all a,b,c,d will populate

Thanks!

[Murthy Ch]

Hi @Samiksha2 

You can achieve this by writing after insert/update BR on target table.

Have you tried anything?

[Samiksha2]

Yes I tried,

var a = current.u_bu.getDisplayValue();
gs.addInfoMessage(a);

var gr = GlideRecord('sn_gf_goal');
gr.addQuery('name', current.goal);

gr.query();
if (gr.next()) {
gr.u_se_bu.setValue(a);
gr.update();
}

[Ankur Bawiskar]

Hi,

how will you determine which record in Goal to update? any reference field on Goal which refers Target table?

what script did you try so far and where are you stuck?

[Samiksha2]

var a = current.u_bu.getDisplayValue();
gs.addInfoMessage(a);

var gr = GlideRecord('sn_gf_goal');
gr.addQuery('name', current.goal);

gr.query();
if (gr.next()) {
gr.u_se_bu.setValue(a);
gr.update();
}