Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Populate Fields Dynamically Based on Selected Table in Record Producer

TEJAS
Tera Contributor

Hello,

I am working on a Record Producer in ServiceNow where I have two variables:

  • Master Table (Dropdown List) → Contains tables like Incident, Problem, Task, etc.
  • Select Fields (Reference ) → Should dynamically show the fields from the selected table.
    TEJAS_0-1741856644653.png

     

Requirement:

  • When I select a table in Master Table, the Select Fields variable should populate the fields available in that table dynamically.
    TEJAS_1-1741856819524.png

     



Issues I am facing:

  • How can I retrieve fields dynamically based on the selected table?
  • What script should I use in the on Change or Script Include to fetch fields?

Can anyone help with the best approach and provide a sample script for this?
And one more thing the scope which i am using is not global it is other 

Thanks in advance!

1 ACCEPTED SOLUTION

GopikaP
Mega Sage

Hi @TEJAS  ,You can write a reference qualified in the field 'Select Field' - 

javascript:'name='+current.variables.master_table.name;

 SS1.png

View solution in original post

1 REPLY 1

GopikaP
Mega Sage

Hi @TEJAS  ,You can write a reference qualified in the field 'Select Field' - 

javascript:'name='+current.variables.master_table.name;

 SS1.png