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 10:58 AM
That's not working unfortunately.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-20-2024 11:12 AM
@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
Regards,
Shyamkumar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-20-2024 11:28 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-20-2024 11:31 AM
@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
Regards,
Shyamkumar
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-20-2024 11:56 AM
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;