Multi row Variable set - Add Rows and data off selection of 1 variable

Dillin  Bradley
Tera Expert

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.

 

DillinBradley_0-1673014434397.png

 

 

1 REPLY 1

Dash2
ServiceNow Employee
ServiceNow Employee