Reference field Doubt

[ST9]

Hi, Having one doubt..
I have a reference field to user table called Opened For, whenever a user is selected in that field User Name will be displayed
Example- In the below snippet, Opened for is DEV2 User01, in user table Name is DEV2 User01
I wanted to know what decide reference field display value?

[Sandeep Rajput]

@ST9 A display column on any table decides which column would be shown when the table is referenced in any other table.

On sys_user table, display true is set for Name field, hence where ever sys_user table is referenced, up on selecting the value in the reference field, Name field value would be shown.

Hope this helps.

[Siva Jyothi M]

@ST9,

Display value of the sys_user decides this functionality. If the display value of the other field is set to true, suppose the email display is set to true, it will display the email in the opened by. This functionality is completely dependent on the sys_user display field.

Mark this answer as correct and helpful if it solves your issue.

Regards,

Siva Jyothi M.

[Brad Bowman · Accepted solution]

This is the column in the table definition where the Display value is = true.  So if you view the User table, in the list of Columns one will have the Display value set.  Absent that, Name is the default Display column for the User table, so if they are all False it will still be Name, or if you set user_name or whatever to true, then that column will be displayed in reference fields and elsewhere system-wide.