How to edit the survey answers after submitted by user

[RK41]

Hi Team,

One of the user wrongly selected the answer in Survey and submitted. Now we want to modify the value for that question. Is it possible to modify the submitted survey answers?

Thanks,

RK

[Tai Vu]

Hi @RK41 

You can view the responses for one survey definition. Survey results are stored on the Metric Result [asmt_metric_result] table.

View the results for a survey

You can try to update the answers there. And also this "Assessment Instance Questions [asmt_assessment_instance_question]" table.

Let me know if it works for you.

Cheers,

Tai Vu

[Hemanth M1]

Hi @RK41 

try below script, replace sys_id with survey instance question sys_id and value with actual field value .

var survey = new GlideRecord("asmt_assessment_instance_question");
survey.get("c83eeb3f97b531101eafb0efe153af78"); //sys_id of the survey question 
survey.setWorkflow(false); //stop to trigger BR, fows, SLA's, workflows
survey.value=4; //modifying value field
survey.update();

Hope this helps.

[Musab Rasheed]

Hello,

It is not possible to edit submitted answers directly in asmt_metric_result or asmt_assessment_instance_question table, however you can do it through background script, I suggest you delete that survey record from instance and retrigger new survey for the user.