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!

[Samiksha2]

BR on Target table , run on after

[Ankur Bawiskar]

BR script should be this

I assume goal field on Target table refers to Goal table

var a = current.u_bu.getDisplayValue();
gs.addInfoMessage(a);
var gr = GlideRecord('sn_gf_goal');
gr.addQuery('sys_id', current.goal);
gr.query();
if (gr.next()) {
	gr.u_se_bu = a;
	gr.update();
}

[Samiksha2]

Thanks Ankur, but value of BU is not populating in the Select Bu field.

[Ankur Bawiskar]

u_se_bu field is of what type?

[Samiksha2]

string