Make reference field only show 1 column from table

[asd22]

Hello, i have a reference field where i only want 1 coloumn to show up thats "budget unit"

How do i go about doing this?

[Ram050670]

@Voona Rohila  Hi, i am looking for similar solution on Portal view but i am looking to show members of the group using reference field. its showing Created and then User i want User to be only shown to select

can you help on this ?

[Voona Rohila]

Hi @Ram050670 

There is no displayvalue set on Group member table so created will be displayed by default when referencing.

To show Group members, Instead of referring the table to 'Group Member' Table, Refer to user table with advanced reference qualifier 

Refer below link

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0831564

[Ram050670]

@Voona Rohila  Thanks for the updates, it was very Helpful link, worked!! i used the below link with sys_user table.

javascript:'active=true^sys_idIN'+getIDs("2d6649bbdbb356004ff5f4331f961924"); function getIDs(grp){var m=GlideUserGroup.getMembers(grp);var ids=''; while (m.next()){ids+= (m.user+',');} return ids;}