Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

In the catalog item i want to Auto populate the location from location table

kranthi2
Tera Expert

Hi,

In the Catalog item form  I want to Auto populate the location from location table if i select location then Street address will be auto populated.

Thanks,

kranthi2_1-1700634214080.png

 

kranthi2_2-1700634284155.png

 

Please help me out on the same.

 

Thanks,

 

 

 

 

 

 

1 ACCEPTED SOLUTION

Navigate to Service Catalog -> Maintain Items

Open the catalog item

Go to the Catalog data lookup definition related list and create new catalog data lookup definition

Shruti_0-1700637749703.png

 

Select your catalog item and location as the matcher table 

Shruti_1-1700637861324.png

Go to Catalog matcher variable definition related list and create new

Shruti_2-1700637966837.png

Select source variable name and sys_id as matcher table field

Shruti_3-1700637981441.png

Go to catalog setter variable definition related list and create new

Shruti_4-1700638054826.png

Select source variable name and street as matcher table field

Shruti_5-1700638090443.png

 

 

 

View solution in original post

4 REPLIES 4

Shruti
Mega Sage
Mega Sage

Hi 

You can use catalog data look up definitions

Shruti_0-1700634918234.png

 

Shruti_1-1700634930259.png

 

 

Could you please elaborate more into this.

Thanks,

Navigate to Service Catalog -> Maintain Items

Open the catalog item

Go to the Catalog data lookup definition related list and create new catalog data lookup definition

Shruti_0-1700637749703.png

 

Select your catalog item and location as the matcher table 

Shruti_1-1700637861324.png

Go to Catalog matcher variable definition related list and create new

Shruti_2-1700637966837.png

Select source variable name and sys_id as matcher table field

Shruti_3-1700637981441.png

Go to catalog setter variable definition related list and create new

Shruti_4-1700638054826.png

Select source variable name and street as matcher table field

Shruti_5-1700638090443.png

 

 

 

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @kranthi2 

 

As you accepted the solution and it is new for me 🙂 , but if i am not wrong you can use Auto populate method as well. 

Create 2 variable

- Location ( Refence to Location Table)

- Street - Single line text

Go to Auto populate tab. and do dot walk to street.

AtulyaLNG_1-1700647621404.png

 

AtulyaLNG_2-1700647644753.png

 

 

AtulyaLNG_0-1700647604345.png

 

*************************************************************************************************************
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]

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