Edit response after submission

Copper Contributor

with the new option to give users the capability to "Edit response after submission" is there any way to track the changes and the number of times a responder has edited their response. Is there an audit trail for the Form owner to see if and when edits have been made to a response?

16 Replies

Hi @Tony McGranaghan 

 

There is no way to know the changes made each time. The form owner can determine whether a response has been modified by checking whether the 'Last modified time' has a value in the Excel worksheet which represents the last modification time of this response.

How can the user edit the submission? I'm not seeing that new functionality.  @Tony McGranaghan 

@helloitscourt you need to check the checkbox in Settings.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

@helloitscourt 

 

... -> Settings -> Options for responses -> Allow respondents to edit their responses.

 

DingkunXie_0-1686099167724.png

 

Thanks! I did that, but still not seeing how I can update the form after submission. @Dingkun Xie 

@helloitscourt 

 

Click "Submit" button to submit the response.

 

DingkunXie_1-1686179020257.png

 

In Thank You page, click "Save and edit later" button, form taker will be prompted to sign in.

DingkunXie_0-1686180647521.png

 

After sign in, form taker will be redirected to Forms portal and see a Form Card shown under Recent tab.

DingkunXie_3-1686179260415.png

Click the card, the response form will be opened, and click "Edit response" button to edit and resubmit the response.

DingkunXie_4-1686179344941.png

 

@Dingkun Xie 

 

If someone starts editing his response and doesn't resubmit before the deadline, is his original response still submitted?

@Dingkun Xie 

 

Lauren88_0-1707130287076.png

 

I cant work out how to get the edit option available to me, any advice please ?

Yes, there would be no change to the original response submitted.

@Lauren88 

 

Responders can only edit their responses if the designer has enabled the setting -

DingkunXie_0-1707181945672.png

 

@Dingkun Xie 

 

This option is unavailable if you create the form from Excel in Microsoft 365

CrHernandez_0-1708375986567.png

 

I choose create the form through Microsoft 365 to link the excel workbook to my form.

If you know a different method to do this please let me know, my goal is to have a form that anyone in my company can see the responses.

 

Regards

One possible solution is to create a form in OneDrive for Business. Once you've created the form, navigate to the Responses tab and click 'Open in Excel' to view the responses in an Excel file. From there, you can share the file with anyone you'd like.

I have a question.  I'm trying to create a form for each of my team members to track their goals, which means they will be going into the form all year with different aspects of their goals and possibly adding updates to others previously documented via the form.  I had thought that letting people go in and edit the response would give me the opportunity to let them edit any submission.  I just want to confirm that function only works for the first form submitted.  If they go back in, it just takes them to the form they previously submitted and won't let them go to a different aspect of the form.  I have a couple ways I can make this work if this is not an option, but it requires them to input more information.  

 

Thanks!

just want to confirm that function only works for the first form submitted

I am not sure I understand what you need.
https://techcommunity.microsoft.com/t5/microsoft-forms/want-to-create-a-form-for-hiring-process-but-...

I guess you may take above link for reference.
That link doesn't work. What I'm trying to do it make a form that lets my associates track information about their goals. Say they have 10 goals. The go into the form to document each one, so that each has a line in the data sheet. They want to go back and add updates to several of those goals. I think the only way they will be able to do that is to actually update the data sheet (which I will give them access to), or have them reenter fields so that we can associate the update line on the data sheet with the goal. I don't think that there is any other way to do it. I'm just trying to find an easier way to track everyone's work where they have all their information in one place. Just typing stuff into a Word doc doesn't sort anything. I've always felt forms was a great way to enter data to a sheet in an easier fashion.
They want to go back and add updates to several of those goals. I think the only way they will be able to do that is to actually update the data sheet (which I will give them access to),


I think what you need is to edit an exist row as approved one applicant from your description.

If you share some specific data,we can have further discussion.