- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thursday
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
.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thursday
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thursday
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
☆ Community Rising Star 22, 23 & 24 ☆
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thursday
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thursday
Thanks Brian, I did this on the referenced table by setting a Dispaly value of a column value to TRUE. It did not work.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thursday
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
☆ Community Rising Star 22, 23 & 24 ☆
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thursday
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
