Unable to auto populate User details from OnLoad Catalog Client Script

Yerasu Mallikar
Kilo Contributor

Hi All,

Can anyone help me to auto populate User details on Catalog Form using OnLoad Catalog Client Script.

As written Script include also.

@Ankur Bawiskar 

Catalog Form:

find_real_file.png

find_real_file.png

 

Script include:

find_real_file.png

find_real_file.png

 

Catalog Client Script:

 

find_real_file.png

find_real_file.png

find_real_file.png

Variable Values:

find_real_file.png

1 ACCEPTED SOLUTION

shloke04
Kilo Patron

Hi,

I would suggest there is a easier and no code option available OOB which you can use to auto populate this.

Please find the steps below:

Navigate to your Catalog Item and there is a Related List named "Catalog Data Lookup Definition" as shown below:

find_real_file.png

2) Click on New button as shown above:

find_real_file.png

3) Click on new button in Related List "Catalog Matcher Variable Definitions" as shown below:

find_real_file.png

Now Configure this as shown below:

find_real_file.png

Now click on New on the other Related List where you can set the values you want as shown below:

Catalog Setter Variable Definitions:

find_real_file.png

Now just set the variable values which you want:

Here I have set Email. Similarly you can set other variable from User Table

find_real_file.png

Result:

find_real_file.png

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

View solution in original post

19 REPLIES 19

What should I need to change either variables types of Employee Location, Department, Manager fields or Catalog Setter Variable Definitions of Employee Location, Department, Manager fields

You need to change the variables for Location / Department / Manager. Change the type from single line text into reference.

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020, 2021 ServiceNow Community MVP
2020, 2021 ServiceNow Developer MVP

---

LinkedIn
Community article, blog, video list

 

Kind regards,

 

Mark Roethof

Independent ServiceNow Consultant

10x ServiceNow MVP

---

 

~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field

LinkedIn

reference of sys_user needs to be taken or need to take any another reference 

Depends on the variabe.

Manager is stored in the user table
Location is stored in the location table
Department is stored in the department table

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark
2020, 2021 ServiceNow Community MVP
2020, 2021 ServiceNow Developer MVP

---

LinkedIn
Community article, blog, video list

 

Kind regards,

 

Mark Roethof

Independent ServiceNow Consultant

10x ServiceNow MVP

---

 

~444 Articles, Blogs, Videos, Podcasts, Share projects - Experiences from the field

LinkedIn

for Manager variable only unable to get the exact table name