When you create a Google Form, you can record the responses in Google Sheets. You can also do the opposite and create a form directly from your table. This will put the two together and automatically record the answers.
Perhaps you are tracking project updates and you want to use Google Forms to track those updates from your team. Or maybe you’re collecting feedback on a new product and want to send out a product survey. If you have a table in Google Sheets and you need a form for that data, this is a great option.
Create a Google Form from Google Sheets
Go to Google Sheets and open a workbook. You can also create a new workbook if you want. You also don’t have to pick a specific sheet to get started. Once you’ve created the form, Sheets will create a new “Form Responses” tab in the workbook.
In the menu, click Tools> Create New Form.
This will create the answer sheets in your workbook and open up Google Forms in a new browser tab with a blank form for your questions. As you add questions to the form, they appear in real time as column headings in the Form Responses sheet in the workbook.
Complete your form setup as usual.
If you create additional forms from the same Google Sheets workbook, the answer sheets will be named and numbered as Form Response 1, Form Response 2, and so on. You can rename the table (s) if necessary.
View form responses in Sheets
Once you share your form with others and start receiving responses, those responses will appear in the appropriate tab in Google Sheets. These, as well as the questions you set up, are added instantly.
You’ll also notice a handy timestamp column on the sheet that automatically records the date and time for each response.
Manage the Google Form from Google Sheets
In addition to creating your Google Form from Google Sheets and receiving the responses, there are a few other things you can do on the form from Google Sheets. It’s a convenient way to edit, view, submit, and more your form without having to open and sign in to Google Forms separately.
From the Google Sheets menu, click Tools> Manage Form. You will see your options in the pop-out menu.
- Edit form: Open the form in a new browser tab to make changes.
- Go to the live form: Open the live form in a new browser tab as your respondents will see it.
- Submit form: Open the form directly using the form submitting options to share.
- Embed the form in a web page: Open the form directly to embed HTML so you can copy it.
- Show the summary of the answers: Open the Responses section in Google Forms with the Summary tab already selected.
- Unlink the form: If you have no longer accepted the form responses, you can unlink the form and then move or delete the linked sheet if necessary.
CONNECTED: How to limit responses in Google Forms
With the real-time integration of Google Forms and Google Sheets, you can save yourself having to choose a storage location for responses after creating the form. This direct connection enables you to view responses and analyze this data on site.
This article was previously published on Source link