Built something you're proud of? Tell the story. A quick G2 review of App Engine or Build Agent helps other developers see what's possible on ServiceNow. Share your experience.

Regarding filling Survey responses from script

Gayathri5
Tera Guru

Hi Experts,

 

Have a requirement based on email responses , we need to set the survey response.

 

Attaching the screenshot of the survey response form, this should be auto

filled from email responses from end users.

 

The below image shows assessment_take2.do in URL, but this is not a table, so let me know if anyone has filled this via script.

 

When I open any survey instance and click user's response, it should be filled with email responses. I made it work till here but how to fill the survey response kind of stuck.

 

If in survey email if user selects 0, it should update 0 in satisfaction and whatever comments user types should be updated in comments section.

 

Gayathri5_0-1716893536549.png

 

 

Regards,

Gayathri

 

5 REPLIES 5

You have to update the asmt_metric_result table. That is the table holding the results of a survey. Find the survey (survey number is reflected on the 'instance' field on the asmt_metric_result table) and update it accordingly.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark