Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

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