Auto populate user information on Load

[tiyasa]

Hello everyone,

So I need to auto fill User information based on the current logged in User. I did search the community and found loads of suggestions but mostly

when a user is selected and the related other fields are populated.

I tried to set the following values to Default for the variables but most did not work

1. Requested For : javascript:gs.getUserName(); Worked fine.
2. Phone Number : javascript:gs.getMobileNumber();
3. Company : javascript:gs.getUser().getCompanyID();
4. Location : javascript:gs.getUser().getLocation(); Returns a value but per the user record of the current logged in user, the value returned is Country not Location.
5. Department :
6. Division :
7. BU:
8. CU:
9. Cost Center :

Additionally, I did try to create a catalog client script on load and fetch the object of the user record, but it doesn't work too.

Thank you ,

Tiyasa

[tiyasa]

HI Dilini,

Strangely, All fields work for me except Company. I have tested the javascript code in Background editor and it returns the value per user record. However in the catalog request form, it shows up as below. Any idea?

[tiyasa]

Just incase anyways searches this thread. I had the reference for this variable set to org hierarchy which is why the value wouldn't populate. I changed to Core company and it works fine.

But importantly, I changed the implementation from javascript in Default Value to Script Include + onload Catalog Client Script.

[nehaagarwal]

I am complete fresher in this. 

Can you explain me how this code works in backend ?

[shloke04 · Accepted solution]

Hi,

For Auto population of the above defined Variables you can write an Script Include and call the same Script Include in an OnLoad Catalog Client Script as mentioned below:

Script Include:

var requestor_details = Class.create();

requestor_details.prototype = Object.extendsObject(AbstractAjaxProcessor, {

  requestor_info: function() {

  var result = this.newItem("result");

  var logged_user = gs.getUserID();

  var user_detail = new GlideRecord('sys_user');

  user_detail.addQuery('sys_id',logged_user);

  user_detail.query();

  while(user_detail.next())

  {

  result.setAttribute("user",user_detail.sys_id);

  result.setAttribute("phone", user_detail.phone);

  result.setAttribute("email",user_detail.email);

  result.setAttribute("location",user_detail.location);

  }

  },

  type: 'requestor_details'

});

2) Then you can write an On Load Catalog Client Script wither on your Catalog Item or on the Variable Set to have the variables populated as shown below:

Script:

function onLoad()

{

  var ga = new GlideAjax("requestor_details");

  ga.addParam("sysparm_name","requestor_info");

  ga.getXML(ajaxResponse);

  function ajaxResponse(serverResponse) {

  var result = serverResponse.responseXML.getElementsByTagName("result");

  var phone = result[0].getAttribute("phone");

  var user = result[0].getAttribute("user");

  var email = result[0].getAttribute("email");

  var loc = result[0].getAttribute("location");

  g_form.setValue('requestor_phone',phone);

  g_form.setValue('requestor_name',user);

  g_form.setValue('Location_user',loc);

  }

}

Replace your Variable Name appropriately in the Set Value Conditions say for example in place of the variable "Location_user" with your Location Variable.

In a Similar Way you can try for other Variables also.

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

Regards,

Shloke

[tiyasa]

Thanks, tried this and works great.