Map to filed with multi-row variable sets.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2024 11:53 AM
Hi all,
when creating a record producer, I see I can check the map-to-field box to map values to the generated record on the associated table. I don't see this option for the multi-row variable set questions (or it disappears after a few seconds), so I have 2 questions
- Is it possible to map from a multi-row variable set?
- If yes, will each row create a separate record in the associated table?
A simple example, I have a record producer that captures details such as item name, quantity and cost for a cost estimate with multiple line items. I'd like to map the values to similar fields in say, the Cost Plan table.
Any additional considerations and best practices would be appreciated.
Best
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2024 12:10 PM
You cannot map a MRVS variable to a field because there could be many rows, so many values mapped to the same field wouldn't work. If you want each row to create a new record on the Record Producer target table, or a different one, you might be able to do something like that in the Script field of the Record Producer - taking the contents of the MRVS plus any variables that are outside the MRVS common to all new records and run a loop that creates the records. Would be fun to try.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2024 01:05 PM
@Brad Bowman Got it! Thanks for the quick response.