Referenced table not displaying column label

AHMED OLAGUNJU
Tera Contributor

I referenced a custom table in my form; the table I referenced has few records. When I want to select from the referenced table, only the Sys_ID of the records in the referenced table is displayed. 
I want my display to show few columns from the referencing form, as we used to have if we referenced a sys_user table

.

AHMEDOLAGUNJU_0-1768468514109.png

 

2 ACCEPTED SOLUTIONS

Brian Lancaster
Kilo Patron

Go into your custom table and make sure you have a field with Display set to True. That will then display that field in the reference instead of the sys_id. Example screenshot below.

BrianLancaster_0-1768493300905.png

 

View solution in original post

Adrian Ubeda
Mega Sage

Hello @AHMED OLAGUNJU ,

 

Apart of changing display value in table definition, you can configure the list layout (Right click) and add/remove fields as needed 

If it was helpful, please give positive feedback! ✔
☆ Community Rising Star 22, 23 & 24 ☆

View solution in original post

6 REPLIES 6

Brian Lancaster
Kilo Patron

Go into your custom table and make sure you have a field with Display set to True. That will then display that field in the reference instead of the sys_id. Example screenshot below.

BrianLancaster_0-1768493300905.png

 

Thanks Brian, I did this on the referenced table by setting a Dispaly value of a column value to TRUE. It did not work.

 

AHMEDOLAGUNJU_0-1768503023041.png

 

Adrian Ubeda
Mega Sage

Hello @AHMED OLAGUNJU ,

 

Apart of changing display value in table definition, you can configure the list layout (Right click) and add/remove fields as needed 

If it was helpful, please give positive feedback! ✔
☆ Community Rising Star 22, 23 & 24 ☆

Thanks, this worked when I tried it. I removed the sys_id from the list and replaced it with my desired field in the slushbucket