Record Producer Submitting sys_id Instead of Table Name – How to Store Table Name?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-01-2025 03:37 AM - edited 04-01-2025 03:48 AM
I am working on a Record Producer in ServiceNow where I have a reference variable called master_table, which allows users to select a table from sys_db_object.
🔹Issue:
When the form is submitted, the master_table field stores the sys_id of the selected table instead of the table name. I need the form to store the actual table name instead of the sys_id.
What can i do for getting the table name .
Thanks in Advance
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-01-2025 03:45 AM
it's correct behavior for reference field.
Since it's reference field it will hold sysId always.
If my response helped please mark it correct and close the thread so that it benefits future readers.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-01-2025 03:48 AM
Hi @TEJAS
True, due to its type as a reference field, it stores the Sys ID, which is the expected behavior here.
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]
****************************************************************************************************************