Customize display of reference field lookup?

[patk1000]

I have a table whose default list view looks like this:

But when I open the form whose field is a reference field, I only see a couple of the columns:

I see the reference lookup documentation, but I'm not going to ask my customers to create their own personalized lists. I just want to be able to set the view for all users of this table when using a lookup.

[Anthony_vickery]

This is the default view for the list, but the Reference List (sys_ref_list) view is used for reference field lookup windows. Open the lookup reference list and right-click the column headings to configure the list layout. You'll notice that the view name (in your second screenshot) will be "Reference List"

If you haven't already, you will also want to ensure customers have read access to the applicable columns.

[naresh1019]

@ Josh Coope

I have a Custom table with one reference field (Email-ID) referencing to sys_user table.

I should able to select Email Id from the sys user table to the custom table. As of now name is getting populated . The display value of all the fields in sys_user table is false. I dont want to change the value of the display field.

[Josh Cooper]

What you can do, or what I would do in this case - take your ordinary reference field and re-label it to "User" or "Mail User" - then in the Configure Layout for the form, click the plus for that reference field and you can select the email address field from that referenced record, and add it as a second field on the form.   Make sure to make it read-only (for that form) with a UI Policy to prevent anyone from accidentally changing it.

Then you'll want to use the instructions above to add the email address to the Reference lookup when you click the magnifying glass, so you can see what email address you're selecting, but both the referenced record display name (user name for sys_user) and that field value will appear on your form.