How to populate the reference field from record producer to the table

[jxa7987]

Hi, 

I have a reference field "department" in record producer, I also have the same reference field "department" in my customized table. I need to copy the value of my reference field to my customized table so I mapped the field value. However, it doesn't copy, the value, the field is empty in the table. 

It has value in the record producer:

But empty in the Customized table:

[jxa7987]

Hi Willem, 

It doesn't capture the value:

[Willem]

Hmm, strange. You do get the 'i'-icon. What happens when you click on that? Do you get the record?

[Willem]

Is there any client script that is influencing this? Overwriting the display value?

[Alok Das]

Is the variable and custom field referring to the same table? Is there any reference qualifier being used in the field on table? Mapping should work. As suggested by others you may try using the producer script.

[Alok Das]

Something like below:

current.u_department = producer.variable_name.toString();
//replace u_department with the field name
//replace variable_name with your variable name on the producer

Kindly mark my answer as Correct and helpful based on the Impact.

Regards,

Alok