Multi row Variable set - Add Rows and data off selection of 1 variable
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-06-2023 06:15 AM
Hello,
I am looking to create a Catalog item that loads data into a multirow variable set after the selection of a variable dropdown and unsure how to do so.
The Variable is named "company_market" and references the cmn_location table
The multirow variable set has 3 variables
"market_name" - this also references the cmn_location table and i would like it to add all the active locations where the "company_market" selected is the parent value. Once this is loaded i have 2 fields that i would like to load for each line item as well.
"ad" - this would reference the "Contact" field for the location
"list" and a list collector that would load all the locations that are active and have the same contact.
Here is an image of what i have on the Portal and how it would look. I am not sure how to get the line items to be added automatically.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-29-2023 05:20 PM
This should be similar to what you're trying to do.
https://www.servicenow.com/community/developer-forum/how-to-auto-populate-multi-row-variable-set/m-p...