Analyze Form Responses
In the Spreadsheet view, go to Form menu > uncheck Accepting responses option to turn the form off
1. Turn the form off after finish collecting responses to perform some analyze
2. After turn the form off, people who try to respond to the form will get the message “This form is no longer taking responses”
View and Share the Results of the Form in a Graphical Summary
1. To view the results in a graphic summary, in the Spreadsheet view, go to Form menu > choose Show summary of response
2. To share the graphic summary with the people who fill out the form, do the following:
- Click Back to editing link on the top of the graphic summary of the form
- Click More actions button on the top right side and choose Edit confirmation option
- Enter a custom message in the blank field before send the response summary
- Select Publish response summary box
- Click Save
View and Share the Results in Google Spreadsheet
1. By the default, the results of the form are displayed in a Google Spreadsheet
2. To share the spreadsheets of the results with other people, click Share button on the top right of the Spreadsheet
- Enter the email address of the people to add them in the share list
- Edit the share permission which allows them whether they can edit or can view only
- Click Share button
3. Apply Google Spreadsheet functions and formulas to perform analysis on the results spreadsheet
