google sheetsgoogle-forms
Long ago, I created a survey that I sent out by email. The responses were recorded in a Google Spreadsheet by filling out a Google Form.
I would like to use that data again, but I cannot find the original spreadsheet. I simply misplaced it. But I do have the original email with a link to the survey that I sent to the candidates.
If I am the owner of the original spreadsheet, is there a way for me to work my way back from the response form to the original spreadsheet?
I have one suggestion: on the next empty column on your Form Response:
=Query(range; "select * where x <> '' order by x" , 1)
Where range is the range of the responses and x is the column that you want to sort. Hide the columns where the answers are automatically inserted.
Google doesn't currently support this feature - there is no way to save a form and have a user return to it later without submitting it.
That does raise an interesting point, though. You can have the user submit the survey and edit their responses later. Instead of forcing the user to page through the rest of the survey to get to the submit button, just add a multiple choice question at the bottom of each survey page (see example below):
By using question logic, we can send survey-takers to the "Submit form" page which then gives them an "Edit this form" link that they'll need to save. Of course, when they come back, they will be starting from the beginning of the survey, but their previous answers will remain filled in.
If this all seems complicated (it is), you may want to try one of the paid survey services (I found SurveyMonkey to be a good value for the money, at least a few years ago), which make implementing this much easier (see SurveyMonkey info here).
Best Answer
The link you still have, contains the ID of the form you created. Building the following URL will bring you to the original form in edit modus.
If you select from the menu Responses(?) > View responses, then it will lead you to the corresponding Google Spreadsheet. Tried it on my account and it worked.