Record Producer Submitting sys_id Instead of Table Name – How to Store Table Name?

TEJAS
Tera Contributor

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

2 REPLIES 2

Ankur Bawiskar
Tera Patron
Tera Patron

@TEJAS  

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.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

Dr Atul G- LNG
Tera Patron
Tera Patron

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]

****************************************************************************************************************