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

jeffreygard1127
Tera Contributor

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)

 

SC1.png

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

 

SC2.png

 

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?

SC3.png

 

 

 

7 REPLIES 7

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @jeffreygard1127 

 

Greetings!!

As far as my understanding here, you can't do not walk, but you can create another variable for this location and make it depend on the SO variable.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Hi @Dr Atul G- LNG thanks for responding. However, we don't need another variable. Is there no other way to achieve the outcome we needed without creating a new variable?

No mate, to show the value we need some place and that is new variable only.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Hi @Dr Atul G- LNG, I created a new variable on the catalog form called Offering. what should I do next?

SC6.png