Populate the reference field from record producer to a table

Primm
Tera Contributor

Hello,

 

I have a field called "Actual Review Due Date" that is a date field 

Primm_0-1710784977649.png

 

I need the data from this field on the record producer I created called CAR to go to a table called Contact Actor Review with the same name. I made the field on the table as a reference field, but when I submit the record producer with the data in the field it never shows up populates.

23 REPLIES 23

That's not working unfortunately.

@Primm , In order to Map Fields from Record Producer to Target Table you need to use following syntax


current.variablename=producer.variablename// Replace variablename with your backend value of Variable

 

You need to write this logic the Script pad which you will see in the Record Producer

 

Regards,

Shyamkumar

 

Please mark this as helpful and accept as a solution if this resolves your Ask.
Regards,

Shyamkumar

So I created 2 variables in a Variable set that are both Date fields on a record producer. Both fields had to be created on a child task table called Contract Action Review task. The parent is called Contract Action Review. I did not create the variables on the parent table. Would that effect the outcome of it not working? 

@Primm , If you’re table on Record producer is Parent then yeah field should be on Parent table, If your Record producer tables is on Child not Required of having the fields on Parent

 

Regards,

Shyamkumar

 

Please mark this as helpful and accept as a solution if this resolves your Ask.
Regards,

Shyamkumar

This is what i have and it's not working. 

 

current.u_users = producer.u_users.toString();

 

current.requested_review_due_date = producer.requested_review_due_date;

 

current.actual_review_due_date = producer.actual_review_due_date;