Display field value instead of sys_id
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-13-2022 01:00 PM
Good Afternoon,
I have created a custom table with a record producer. On the record producer I have a list field a list collector variable that is mapped to a list collector field. When I submit from the record producer and go to the table to review the record my list values show as sys_ids. Is there a way to display the field value instead of the sys_id? Also I noticed when I open the record it does not display the values on the table form.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-18-2022 04:58 AM
Please ensure referenced table have display column. Otherwise, Select a field as the table display value
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-12-2023 02:57 AM
as the result is an object ( represented by sys_id) you can use dot walking in the producer.[variable_name].[column_to_display]
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-12-2023 03:51 AM
HI @jaubert ,
I trust you are doing great.
This is showing sys_ids as the display value is not set for the reference table.
Just configure the table and set Display value to true for the column which you wanna see as display, this will resolve your issue.
Please mark the answer correct if it was helpful.
Regards,
Amit Gujarathi
Was this answer helpful?
Please consider marking it correct or helpful.
Your feedback helps us improve!
Thank you!
Regards,
Amit Gujrathi