Every day, websites and blogs fill Google Forms to capture user feedback. But have you ever wondered if only specific people are filling the form out? Looking at who is filling out your forms can be a tedious job, but now you might have an easier way! This article will show you how to track the information from each individual user who fills out a form on your website or blog.
How Google Form Works
If you’re looking to see who responded to your Google Form, there’s a bit of a trick to it. The easiest way to find out is go to the form itself and hit “View Responses.” This will open up a table in your Google Doc that shows all of the responses, with the name of the respondent next to it.
Create the form
As you start to build your Google Form, it may be helpful to take a step back and imagine the end result. What will this form provide? What information will someone have after completing it? With that in mind, focus on creating forms that cater to specific needs.
For this blog post, we’ve created a Google Form that gathers data about who responded to your email blast. The form includes a pre-populated list of invitees and an optional comment field for users who responded.
Step 1: Open the Google Formslettereverything in black so that you can easily see where all of the data fields are.
Step 2: Click on the blue “Create Form” button at the top right of the screen.
Step 3: Choose “Google Sheets” as your form type and enter a title for your form.
Step 4: Select the email address from which you sent out your email blast and click on “Next.”
Step 5: Fill out all of the required data fields and click on “Next.”
We suggest including a comment field for those who respond to
Mark the names that received response in your form
1. Sarah 2. Jessica 3. Brittany 4. Brooke 5. Kennedi 6. Kaitlyn 7. Ashley
Export the responses to excel to export back into wordpress
If you have been using Google Forms to gather data, you may want to export the responses into a spreadsheet to analyze. While you can export the spreadsheet as a PDF or text file, we recommend exporting it as an excel spreadsheet for easy navigation and analysis.
First, open your Google Form in google forms. Once open, click on the “Form Settings” button in the top left corner of the window. Under “Form Options,” click on “Export Responses.” In the Export Responses dialog box, select “Excel” from the format dropdown and click on “Save.” If you’d like to copy all of the responses into a new document, be sure to check the “Copy results to new document” checkbox. Finally, name your export file and click on “Export.”
Once your export is complete, you will have a new excel file that contains all of your responses. The first thing you will want to do is split this file into individual sheets based on column header. Be sure to include both the date and time columns in your header so you can identify when data was collected and by who.
Now that we have our header information set up, we can
Post in blog and get autosuggestion words based on response
Bloggers, do you use autosuggestion words when you type in your blog posts? If so, what are some of your favorite autosuggestion words? I’ve been trying to get better at this and come up with a list of my favorite autosuggestion words! Here are three of mine:
Conclusion
In conclusion, if you’re looking to see who responded to your Google form, you can use the “Post Responses” link located at the bottom of the form. Just look for the “See Post Response Data” option outlined in red below.
Tips For Responding to Comment Cards Better on WordPress
It’s increasingly more common that your commenters respond via comments, but that doesn’t mean things aren’t a little bit more complicated. The good news is there are some simple shortcuts and hacks you can use to make responding to comment cards easier still. Here’s how