Populate values based upon the variable selection.

JVINAY
Tera Contributor

Hi Team,

I have created 4 fields in the form ( Record producer ), based on the questions from " Is this associated with a business application (APMID)" section

the remaining 3 questions are designed to auto populate  values based on the " Is this associated with a business application (APMID)"

These 5 fields are linked to the Business application ( cmdb_ci_business_app) .

JVINAY_3-1742294233345.png

 

fields and backend values :

 

 

I have written On-Change client script , but the values are not populating as expected. could you please assist me 

JVINAY_1-1742293903028.png

JVINAY_2-1742293950797.png

Thank you .

 

 

11 REPLIES 11

@JVINAY 

it should be stored after submission.

I could see the icon next to those variables

Did you check data for those variables is stored in "sc_item_option_mtom"

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

Hi @Ankur Bawiskar ,

These Data Stored in "u_cloud_intake_task" table.

@JVINAY 

Did you open that RITM as admin?

If it's not showing data for non-admin then it's access issue

whenever you submit REQ, data for that variable in backend is stored in this table "sc_item_option_mtom"

Did you check if data for those variables is stored in that table?

Any other script is clearing those variables?

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

Did you open that RITM as admin? - yes

Did you check if data for those variables is stored in that table? - yes , Data Stored in "u_cloud_intake_task" table.

based on the Central intake request , below APMID filed value stored in the form but remaining 

APM#, IT fun Org, Busiess unit fileds data not stored.

Any other script is clearing those variables? -No , I have checked all the scripts.

in the Record Producer script section below script is written.

JVINAY_0-1742382560007.png

The above script for other fields auto population.

Thank you

 

 

@JVINAY 

please check whether data got stored in question_answer table for those 3 variables for your record?

whenever a record producer is submitted an entry is made for each variable in that table

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