How to use Google Forms

You might think you know everything about Google Forms but actually, there is still which you have to learn about Google Forums. We are here to make sure whether you know all the tricks of Google Forums.

Choose Your Response Destination

If you are a moderate user of Google forms, you might already know that you should choose anyone between the Spreadsheet and the form. But you don’t which one you should choose and why. For starters, there is a button to choose their results destination that says “Choose Response Destination”. Choose and click which one you want.

Google Forms

 

If you want to view the files easily or want to manipulate the data, then better go with a spreadsheet, to store the results. You might prefer to keep the results in forms though if you are expecting more than 400,000 responses as that’s the limit of rows in a regular Google Spreadsheet. If your results are in forms, you can always export them as a .csv file and import them into your desktop spreadsheet software anytime.

Regardless of which destination you choose, you can always go to Responses > Summary of Responses to get a more visual view of the results, which is perfect if most of your questions were multiple choice or allowed to be graphed in some way.

Google Forms

Add Spreadsheet Responses To A New Sheet

Just before keeping your form results in a spreadsheet, you can put your results into a new sheet on an existing spreadsheet. This means that if you are doing regular staff surveys, you can easily compare your results by using the new spreadsheet. So it makes your work easy. While you chose response destination, just choose an existing spreadsheet and a new sheet will be created for you.

Notification Rules

Although many people know that it’s possible to be notified when people fill out your Google Form, it’s not entirely obvious how you set this up. For starters, it can only be done when your results are going to a spreadsheet (see above for setup). In the spreadsheet, go to Tools > Notification Rules and choose whether you want to be notified every time or as a batch.

Google Forms

Embed iFrame Of Form With Custom Width And Height

If you want to use the Google form as a contact form on your website or somewhere elsewhere it is useful to embed the form as an iFrame, it’s easy to do so. Go to file> Embed and select the width and height of your iFrame. Then just cut and paste the code.

Google Forms

Add Page Breaks

In order to make your form clean up and seem it to be more manageable, it is good to add page breaks. To do so, click on “Add Item” and choose page break. For each page, A header and description should be assigned, which permits you to separate each of the pages into questions of a certain type of respondent. These pages can then be used for threading and logic.

Google Forms

Use Section Headers To Add Passages

To add a section header, use exactly the same process as for adding a Page Break. The best possible reason for a section header is to separate questions that are all related to each other but don’t need a whole new page. For instance, if you are a teacher you could enter a short passage and follow it with questions relating to the passage. This scenario can also be done using the Page Break as shown.

Google Forms

Create A Pre-Filled URL

If you want to pre-fill some answers for your respondents, go to Responses > Get Pre-filled URL. Then just fill the form out as you would like the respondents to do for any given question and save. You might want to do this on website contact forms in order to change the color of cells when a certain phrase is present.


You May Also Like:Tips To Send Confirmation Emails With Google Forms