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

[Ajay37]

Hi Ankur,

Thank you. Why I am trying to do this is, I want to show the users of particular group in that reference field, so I referred to "group member" table and have given condition as group is xyz. I also tried an alternative, by creating two fields A and B, A is referring to group table and have set up the default value of required group in that field and made B dependent on A, it worked successfully. But it result in creation of extra field, so in order to eradicate that, I am trying this way.

[Ankur Bawiskar]

Got it.

You can make the User field as Display=True if you wish to since this table is not much used as reference.

Let me know if I have answered your question.

If so, please mark appropriate response as correct & helpful so that this thread can be closed and others can be benefited by this.

Regards
Ankur

[Ajay37]

Thank you. Will do that. 

[Ankur Bawiskar]

You are welcome

[Ayushi Gaur]

Hey @Ajay37 , currious to know that did you find a way to change 'sys_ref_list' for a particular field only.