I've recently conducted a survey using Google Forms. The graphs and charts in the summary section are enough for me. However, I want to clean 10% of data (change ambiguous answers). Is there an easy way to do this using the spreadsheet that is connected with the form?
Google Forms – Data Cleaning Techniques
google-forms
Related Solutions
Google-forms – How to save users’ responses in Google Form survey as they continue from page to page
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).
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.
Related Topic
- Google-sheets – How to have multiple users complete a single form in Google Forms
- Google Sheets – Forms Data Manipulation
- Google-sheets – way to get the summary section from a form into a Google Doc
- Google-apps-script – Display updated data from a Google Form
- Google-sheets – Tech Inventory – Forms Data Manipulation In Google Sheets
Best Answer
I'm sorry, there isn't an "easy way" like using a built-in feature but you could use Google Apps Script, an add-on or a third party app.
If you will go for Google Apps Script, you should know about JavaScript and the Google Forms way of making Google Forms question to Google Sheets column mapping. Most of the questions are mapped 1 to 1 but grid questions are mapped 1 to many, where many is the number of question option rows.