Here is the context of this question. We used Google Forms for an election of 6 people. I want to know if it is possible to delete individual responses and then recover all responses (deleted and not deleted). For example, on Google Docs you can look at everyone's edits and recover deleted items from previous dates. Is this possible with Google Forms and if so, how can I get all of this information.
Google-forms – Is it possible to recover deleted responses from Google Forms
data-recoverygoogle-forms
Related Solutions
Yes, you can, by using the Go to page based on answer feature. This implies that you have to divide your form into pages, which is easy to do.
Given you have already created your form with three questions:
- Do you like cats?
- Which kind of cat do you like most?
- Why do you dislike cats?
Create a page for each section of your form:
- Click the Add item button
- Select Page break
- Move question 2 into your new page (drag-and-drop)
- Add a new page break
- Move question 3 into your new page
You should now have three pages; one for each question.
Now make your first question a Multiple choice question, and tick the Go to page based on answer checkbox:
Add options to your question (Yes and No). For each option, select the page to go to if that option is selected:
On page 2 (with the question Which kind of cat do you like most) you would want to skip the next page (Why do you dislike cats):
That's it. I've setup an example form here, feel free to play with it: https://docs.google.com/forms/d/1wGKiAO8s1CjgW5puNrCZYooa7mFJHq0BygBvw3fHFNg/viewform
Instead of sharing the responses sheet use a IMPORTRANGE and FILTER or QUERY to pass to a second spreadsheet only the "public" responses share that spreadsheet with them.
The formula will look like the following, assuming the in Column C will include "Public" for the public responses.
=QUERY(IMPORTRANGE(spreadsheet_key,reference),"Select * Where Col3 = "Public")
Related Topic
- Google-sheets – Cannot plot null values in Google Forms
- Google-drive – Group file responses from Google Forms into individual folders per submission
- Google Forms – Can Response ID Be Accessed?
- Google-sheets – Google Forms Quiz Response Sheet
- Google-sheets – How to get responses in Google Forms to automatically be updated when updating the spreadsheet
Best Answer
If you didn't save the form responses to a Sheet before deleting them, they cannot be recovered after deletion.
I contacted Google support about this issue in the past and they told me the same thing - they don't have an undelete button for Forms.