Can I dotwalk a field on a specific table to be used as reference for a catalog form?

[jeffreygard1127]

hi guys!

I am creating a new catalog form that contains a reference field. The field is call Site Location and is reference to the Offerings table (service_offering)

So on the variable, I added a condition that it will only look for a specific Offering that's why I used the sys ID of the Offerings

This is what the offering looks like. As you can see, there's a LOCATION field on the Offering and it contains the following countries: United States, Australia, Japan, Germany and South Africa. These are the site locations I need to appear on the field of the catalog form. How can I do that?

[Dr Atul G- LNG]

Hi @jeffreygard1127 

There is a feature called auto-populate in the catalogue item variable.

I am not 100% sure it will work on the list collector as you are storing location value as a list collector but give it a try.

[jeffreygard1127]

Hi @Dr Atul G- LNG, it didn't work correctly. It shouldn't be auto-populated because users should be able to select which location they're from. Plus, it populates the fields with all of the countries, it should have been a list:

[Dr Atul G- LNG]

Hi @jeffreygard1127 

So if I understood correctly, if a user selects an SO then you want the list collector should get these locations and then the user can select one of them and submit the request.

if this case mate, I am not able help fully as this need some scripting which i cant do.  here is link which can be helpful

https://www.servicenow.com/community/developer-forum/populate-list-collector-based-on-another-refere...