convert sys id

[Yuval Lanton]

Hi.

I am trying to auto populate the 'Previously assigned to' field with the value of the 'Assigned to' field , but i get only sys id.

How do I convert the sys id to the value I need?

[Shekhar Navhak1]

can You please post your code here?

[Basheer]

Hi @Yuval Lanton ,

The Assigned to is referenced to the sys_user table and if you access it you would get the sys_id of that user record.

If you want its full details then you need to do as below at server level

var assignedTo = current.assigned_to;
var userRecord = new GlideRecord("sys_user");
if(userRecord.get(assignedTo)){
current.previous_assigned_to = userRecord.name; //If you want name to be populated.
//Fill in what ever you need from the userRecord object
}
 

  If you want at client level you need to do Client Script + Display BR (or) client script + Script include.

Let me know if you want more details on how to do via client side.

[Shashank_18]

use getDisplayValue() to show the display value of that reference field.

example : current.assigned_to.getDisplayValue();

[Teju Dhoran]

Hi,

I guess your firld 'Previously assigned to' is of type string. Change type to reference and use sys_user table as reference table.