Google Forms – How to Reset Responses

google sheetsgoogle-forms

I want to reuse a GoogleDocs Form, with (almost) the same Form, but with fresh Responses.

I did copy it, but I don't know how to reset responses (not reseting the form itself, i.e. Form/Delete Form).

I manually erased the previous entries. However, they are still treated as entries with values set to ''.

Is there a way to do it?

Best Answer

You should be able to get a 'fresh' form by deleting the entry rows. That is, select the entire row by clicking the row number(s), right-click, and choose Delete row.

(source)

I just did the following test case:

Create a simple form
Submit a response
In the spreadsheet, select the response row, right-click, delete row
Submit a new response

Result: The second response posted in #4 is listed on the first row. The response summary shows only one response.

Related Solutions

Google Forms Script – Delete Responses Counter

Each form is a distinct object, separate from the spreadsheet itself. The spreadsheet is merely the destination for the form responses, for the purpose of reading and using them, and responses sent to the spreadsheet are no longer connected to the form itself. The actual responses that are connected to the form are stored with the form.

If you want to clear the form responses, you can do so by going to the form editor and selecting

Responses > Delete all responses

To do so in a script you need to do something like this:

var form = FormApp.openById(id);
form.deleteAllResponses();

Note: The warning given when deleting manually states that 'responses already sent to a spreadsheet will not be deleted'. It should read '...will not be deleted from that spreadsheet'

Google-drive – Google Forms – Checkboxes – Edit Option

You might have to open up the spreadsheet where the results are stored, and make your own manual summary. I don't think that Forms automatic summary can cope with this in any way.

Best Answer

Related Solutions

Google Forms Script – Delete Responses Counter

Google-drive – Google Forms – Checkboxes – Edit Option

Related Topic