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]

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