Populate the reference field from record producer to a table

[Primm]

Hello,

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

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.

[swathisarang98]

@Primm 

Could you please try as below,

as the variable you are fetching are from variable set try below,

current.actual_review_due_date = producer.contract_action_reviewer.actual_review_due_date;

check variable set internal name once i assumed it would be something like this contract_action_reviewer

Please mark this comment as Correct Answer/Helpful if it helped you.

Regards,

Swathi Sarang

[Ramesh_Naidu]

@Primm : As you are using multi-row variable sets. you are not able to access those variable. If you move those to single row Variable set. You will be able to access using 

current.actual_review_due_date = producer.actual_review_due_date;

Thankyou.

[Primm]

Here is my situation. I have a record producer called Contract Action Review, that is on the Contract Action Review table. I have a second table called Contract Action Review Task table that have the following fields on them "Requested Review Due Date" and "Actual Review Due Date" . Those two fields are in the variable set for the record producer Contract Action Review. It's not on the Parent table Contract Action Review.

When a user submits a record, the Parent table then creates a task form from the Contract Action Review Task table with those fields on it. I need those fields from the record producer to be map to the Contract Action Review task form. 

I hope that gives more of a clearer insight to what's going on.

[swathisarang98]

Hi @Primm ,

In your record producer make the field as Date ( or same as backend type of Actual Review Due Date from table (if its Date/time make it date/time))

and in record producer script type as below,

Syntax:

current.<backend name of field in table> = producer.<backend name of variable in producer>;

if the variable is in variable set then try below,

current.<backend name of field in table> = producer.<variableSet_name>.<varibale_name>;

Note: while creating the variable in Record producer try to keep the same name as backend name of field in table if you are trying to map it .

Please mark this comment as Correct Answer/Helpful if it helped you.

Regards,

Swathi Sarang