question Re: Sys_id to string value. in ITOM forum

Sys_id to string value.

charmon — Wed, 24 Sep 2014 15:42:14 GMT

I'm new to service now administration so please bare with me. I'm building a form and I need a few fields to autofill the information and its returning the user name as the sys_id not the string value. any help would be greatly appreciated

function onChange(control, oldValue, newValue) {

var name = g_form.getReference('application_name');

g_form.setValue('appowner', name.u_appowner);

}

the appowner field is populating the correct users sys_id but I need it as the actual name. Thank you in advance.

Re: Sys_id to string value.

salvadormar — Wed, 24 Sep 2014 16:05:04 GMT

Try this:

var name = g_form.getReference('application_name').fieldname;

...where 'fieldname' is the field name of the User table where the name of the person is stored.

also, 'name' is widely used...I recommend 'myName' instead.

OR....try this:

var myName = g_form.getDisplayValue('application_name');

g_form.setValue('appowner', myName );

Re: Sys_id to string value.

Anurag Tripathi — Wed, 24 Sep 2014 16:20:50 GMT

Hi Chad,

if appowner is a reference field to the sys_user field then it will work as expected, else you will have to extract the user name from this name.u_appowner in the same was as you extracted u_appowner from application_name, ie using getReference.

a better approach will be that you pass application_name to a script include using glideajax and there you can directly extract the u_appowner and get the display value of u_appowner by using .getDisplayValue().

Re: Sys_id to string value.

Ken83 — Wed, 24 Sep 2014 16:29:40 GMT

Using the .getDisplayValue() should give you what you are looking for.

function onChange(control, oldValue, newValue) {

var name = g_form.getReference('application_name');

g_form.setValue('appowner', name.u_appowner.getDisplayValue());

}

Re: Sys_id to string value.

charmon — Wed, 24 Sep 2014 16:52:43 GMT

Thank you for all the quick responses. The community involvement is rather refreshing.

Kenneth, when I used that .getDisplayValue()) it wouldn't return the sys_ID of the user anymore.

Anurag you win the prize on this one...... the appowner field was set to a single line text I changed it to a refrence to the sys_users and it resolved the issue.....

just so I dont get to many eye rolls on this, I have no training in service-now admin at all. I walked in one day and was told Hey guess what you are in charge of now........ so everything is self taught. alot of looking at what the company already had setup and trying to duplicate it on new work...... unfortunately it appears that a lot wasn't setup in the most efficient manor to begin with.

Again thank you for all the help everybody its much appreciated and I'm sure you will all be hearing from me again!!

Re: Sys_id to string value.

Victor Ruiz — Tue, 06 Jan 2015 14:06:14 GMT

I just experienced the same issue and your posting resolved it.....thanks a bunch !!!

Re: Sys_id to string value.

rajvirk — Wed, 07 Oct 2015 04:17:26 GMT

can you please provide us example with some code? i am experiencing similar issue

Re: Sys_id to string value.

Anurag Tripathi — Wed, 07 Oct 2015 08:37:11 GMT

What exactly do you want to achieve....this is an old post....and if going through it doesn't solve ur issue then....tell me what you are trying

Re: Sys_id to string value.

Troya1 — Wed, 17 Nov 2021 17:12:17 GMT

Thanks! I used the below code to copy list collector values to a text box in order to include the variable in my flow designer email.

var myName = g_form.getDisplayValue('application_name');

g_form.setValue('appowner', myName );