sys_id instead of value displayed

[jean-pauldehaas]

Hi all,

i have a catalog item as follows:

variable 1: Owner of the team (reference to sys_user)

variable 2: email address (single line)

variable 3: organization (singe line)

Variable 2 and 3 should change when variables  1 changes, this works for both only variable 3 is displayed with the sys_id of the organization.

Catalog client script used:

what am i doing wrong here ?

[Jaspal Singh · Accepted solution]

You need to change the Organization variable to be of type Reference instead of Single line text.

[Ankur Bawiskar]

Hi,

2 ways

1) change the variable type Organization as reference to the table which is being referred by field u_organization

2) use GlideAjax + Script include along with onChange client script to get the display value of organization

You can decide which approach suits you and do the needful

Regards
Ankur

[jean-pauldehaas]

hi,

i changed it to a reference field that looks at the sys_user table but now it stays empty on the catalog item

[Jaspal Singh]

Reference has to be to the table that Organization field is referenced to on the User table & not reference to User table itself.

[jean-pauldehaas]

ahhh so more like this: