Regenerate the link to return to a survey

We have anonymous users who fail to save the link they get when they save and exit part way through a survey. What is the easiest way to regenerate the link, given that one of the required questions was their e-mail address?

We were thinking we could lookup the survey by name in the database to get the survey guid, but then what's the best way to get the response guid?

Thanks!

Doug Evans
IT Manager
Association of Washington Cities

[pwiesner]

The easiest solution will most likely be to export the survey results and find the respondents partial response. The left most column will contain the response id. Please note that you will need to ensure that the "Report Incomplete Responses" option is enabled before exporting the results. You can find the "Report Incomplete Responses" option on the Settings -> Preferences page.

Once you have found the response id it can be used to find the response GUID, which is used as the key when resuming responses.

--BEGIN
SELECT [GUID] FROM [ckbx_Response] WHERE [ResponseID] = FOUND_RESPONSE_ID
--END

Once you have found the GUID you can use it to reconstruct the resume URL. You will want to append to the survey's base url. For example if the url for my survey were:

www.mysurvey.com/Survey.aspx?

and the GUID was

ff578eaa-57da-4435-a152-af3bde3eb13b

The users resume URL would be:

http://www.mysurvey.com/Survey.aspx?...2-af3bde3eb13b