Populate the reference field from record producer to a table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-18-2024 11:42 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-20-2024 09:37 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-20-2024 09:39 AM
That did not work either.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-20-2024 09:54 AM
@Primm what was the error ?
Could you please try something like below,
current.<backend name of field in table> = producer.<variableSet_name>.<varibale_name>;
Please mark this comment as Correct Answer/Helpful if it helped you.
Regards,
Swathi Sarang
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-20-2024 10:12 AM
Table name is x_g_duas_abm_contract_action_review_task
Backend name of field actual_review_due_date
requested_review_due_date
Variable set name is Contract Action Reviewer
Variable names are the same as the backend names
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-20-2024 10:29 AM
@Primm : use current.actual_review_due_date = producer.actual_review_due_date;
But both the fields should be of same type.
Thankyou.