How to set the Custom list view for reference field?

[Ajay37]

Hi All,

I have gone through several community threads and blogs, but I didn't find answer. I have a reference field on Table which is referring to "sys_user_grmember" table. By default it is showing the "sys_id" when I lookup through reference field, but I want to show the custom list view with only "user" column in the list. Is it possible to configure list for only this field.

I have tried using "sys_ref_list", but it effects globally. I also tried by configuring sys_popup view, but it is only effecting at the form level when we click on the info icon beside field. 

Regards,

Ajay

[Kieran Anson]

Hi Ajay,

You need to change the display column for the table if you want a particular column to display for reference fields.

[Ajay37]

Hi Kieran,

Thanks for the reply, but changing the display value effects globally right? I just want it for only specific field not for global.

[Kieran Anson]

Yes however as the table is infrequently used I'd suggest doing so. Or adding a new field that calculate the display value as user (group name)

[Ankur Bawiskar · Accepted solution]

Hi Ajay,

I don't think you can set it only for this field

When you click the lookup it would show the sys_ref_list

That would be a global change.

Also marking User field as display=true would be a global change.

But if you are not using this table as Reference table in any of your existing tables you should be fine with making the dictionary change for User column as Display=true

Regards
Ankur