The Zurich release has arrived! Interested in new features and functionalities? Click here for more

Need help on custom reference table

huyjor
Tera Contributor

Hello everyone

I created the form and I have a field that has reference table.So each time i click on the magnifying glass to select the item from the course name list, it comes back to me as "Created 2023-12-16 23:48:25"
or the sys_id. I'm not sure why. Am i missing anything? Do i have to convert the sys_id to the actual name

 

Thanks 

 

2023-12-17_18-22-34.png

 

this is the reference list below. I just want to select the course title so it will show up on the course name

item on list.png

1 ACCEPTED SOLUTION

Tony Chatfield1
Kilo Patron

Hi, based on your description I would suspect that the 'display value' for the reference table is set to the 'sys_created_on' field and not to the table's 'name' field, which from your second screen shot is 'Course Title' ?
Select a field as the table display value (servicenow.com)

View solution in original post

1 REPLY 1

Tony Chatfield1
Kilo Patron

Hi, based on your description I would suspect that the 'display value' for the reference table is set to the 'sys_created_on' field and not to the table's 'name' field, which from your second screen shot is 'Course Title' ?
Select a field as the table display value (servicenow.com)