Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

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)