Monday, October 12, 2015

Google Forms: Changing Response Location

Unless you have specified otherwise, Google Forms will create a new responses spreadsheet for each of your forms.  Did you know you can change this location?  One reason why you might want to change this location is to have responses from multiple forms in the same document.

Scenario:  I'm doing a review activity in all of my 6 periods of Science.  I'd like to have all the responses in the same document to be more organized and save me some time while I'm looking over the results. 


Step 1 - Create your form for the first period as usual.  Forms will automatically set up your responses document.  

Step 2 - Copy and rename your form for the second period.  Forms will automatically set up your responses document, but you are going to change that.  Click on the "Responses" menu and choose "Change response destination".  

This will open a window.  Mark the option for it to be on a new sheet in an existing spreadsheet and then click "Choose".

It will open another window where you can choose the spreadsheet where you would like your responses to go.  In this case, I'm going to select Science Review Period 1.  Choose your spreadsheet and then click "Select".

Now, if you go to the spreadsheet you chose, you will see both form responses tabs are there.  You can rename the tabs so you know which period is which.  It puts the new form in front, so the "Form Responses 2" tab will be my Period 2 class.   

Step 3: Repeat Step 2 for all the other Science periods.  

Step 4: Delete the extra response sheets that were created when you made the forms since you won't be using them.

All done!  Handy, right?  

If you are new to Google Forms - check out my Google Forms 101 post.

Stop in again soon for more helpful tech tips!

No comments:

Post a Comment

Thank you so much for taking the time to leave a comment!

Helping teachers incorporate technology, one tech tip at a time.