How to create a survey with Google Forms (full tutorial)
HTML-код
- Опубликовано: 16 сен 2024
- Learn how to create surveys with Google Forms
Download the checklist at - grumo.com/gforms
Google Forms is a very powerful free online form creator that can be used to create custom surveys.
In this tutorial you'll learn how to create a survey with Google Forms and how to set up automatic email notifications to the google form creator and the user using Google Scripts.
For more videos like this subscribe to this channel here: www.youtube.co...
Thank you so much for your tutorial. I have submitted my 1st survey and have started receiving responses. I love the spreadsheet with all the information. Awesome!!!
Thanks!
One of the best tutorials I've ever seen on RUclips. Just created my first survey using Google Forms. Thank you.
Thanks Scott!
I have used google forms for a while, buit found that it didn't offer the features I need as I regularly create surveys for my course. I have taken to using another free survey platform a1surveys.com which is working our really well. I'm finding it far easier to manage the surveys and extract the reports.
I am not a coder and following this video was my very first experience editing code. Those of you who are experiencing code errors, you have created a typo somewhere in the code he provided during your editing process. I have created 3 separate surveys using the exact code he provided that have worked perfectly. And thank you Miguel for putting this together!
Thanks again!
Learned that a random space in the survey header can throw off your JavaScript. Thank you, Miguel.
Cheers!
Thx really helped me with ICT
My teacher told me and my classmates to watch or research how to create a online survey using Google forms this really helped
🌸"Thank you!"🌸
Glad to hear my video was helpful for your assignment!
Thank you.... Wow... All the questions in my mind was answered through your tutorial... God bless
Glad it was helpful!
Thank you much. This video was very thoroughly & your instruction took the guessing game out by showing a step-by-step formula. YOU ROCK!
My pleasure Anne!
playing with it I did not want users to again receive their input. it was really fun trying to understand the code even though I do not know anything about coding
I was able to successfully complete a survey by following this video. However, I do have a suggestion for future tutorials. Remember that not everyone watching your videos is as experienced or proficient as you are. I struggled to see how you got to certain commands. For example, you would say something like "Next do such and such ..." but you failed to mention HOW you got to the next page/optoin, like "Click the three little dots in the lower left ..." or whatever. I would have to rewind, sometimes over and over, to catch your quick Click to discover how to get there. Toward the end (of the survey part -- I haven't yet delved into the script editor stuff), I wished that I had chosen a different tutorial but, by then, I was too invested and almost finished. Thanks, anyway -- mission accomplished -- but I hope you will consider my input.
Thanks for your feedback!
Thank you for the info! Newer used Google Forms for surveys creating...
This was very helpful. Thank you so much.
Thanks you very much!
You're welcome!
Thank you for the email. Unfortunately, the email/script did not work for me I am not receiving the responses in my email (followed all your instructions) but you did make it easy to do the form so thank you. I would suggest making a newer video as some of access points in google forms has changed (example trigger info and authorization).
Now I’d recommend you use Zapier to trigger emails from Google Forms.
@@GRUMO thank you!
I'm not sure if you are still monitoring comments on this video - thank you it helped me so much! I am however, having a problem with getting admin email upon submission. Any suggestions?
My pleasure! - Did you give enable permissions on the submit trigger? - Alternatively, now there is a simpler way to trigger custom notification emails that doesn't require coding. You could use Zapier which can integrate with Google Forms and you can set a Zap that sends the emails when a new form submission is detected.
This was very useful and easy to follow! I'm up and running with my pre-healing session survey. Thank you.
thanks,
very good description and usefull video
Glad it was helpful!
BRAVO!! GRACIAS SENNNNOR!!!!
Thanks Florence!
Awesome video! Can you make an updated version for 2023? There is no tools > script area :)
Thanks, now you can access the script area under Extensions > Apps Script
Amazing video... thanks a lot
Glad you liked it Ireneo!
Love this video, the most easiest and comprehensive I've seen. Thank you. Curious about the code if it is a multiple choice question and different email responses to those answers. What would be the code for that? Could you point me to the right direction? Thanks
Thanks. I'm not sure I understand the question. Currently, the email confirmation will contain all the responses no matter which type of form field is chosen.
This is amazing tutorial.. Thanks a lot.. may Allah bless you 💖🌺
You are welcome 😊
Very helpful!! Thank you!!!
You're welcome!
Very useful gs code. Thanks. In the case of not wanting to get more emails, could we just unlink the form?
Thanks i completed it well and all is set but-
Getting "undefined" in email body that user will receive for 2 specific rows only.
Office Cleanliness: undefined
Lunch area Cleanliness: 2
Please respond.
thank you so much.. i am happy that i have learned a lot from this topic...
You’re welcome 😉
I appreciate the tutorial you provided!!
Thanks for making this video, it really help.
thanks for your time and tutorial
Bro you are amazing, great video, on point 👌, straight and working perfectly. Thanks bro. Keep it up
Thanks!
Dear sir thanks for really helpful video. Sir is it possible to create custom input validation rule using formula (e.g despite it can be easily done using a pre-existing rule, is it possible to use len() function to validate input as example?)
Helll yeahhh... you are very awsome mannn you help me alot with my Research Study
Thank you for the great tutorial! Much appreciated!!!
You're welcome!
Thanks I need to be able to make retarigeting so to know how many open the form including the ones that didn't finish the foorm. And also when promoting in facebook to know this in order to show them again the add. Can someone help, please?
Hi Simona, the only way to use the retargeting pixel on a Google form is by embedding the form inside a regular web page and adding the code for the pixel to the page. However, there is no current way to track whether someone started but didn't complete the form. You could use Google Analytics to track how many unique visitors landed the page with the embedded form and compare that number with the total form submissions. That would give you a rough estimate of the form conversion (ie: form visitors vs. form completions.)
Hey, I've been following the video up until 14:00. However, I've encountered with an error on the code. I was hoping you could help me out.
Thanks
Thanks a lot
This is an excellent video. Is there a way that the person who fills in the form be allowed to see the responses without allowing email address but the chart representation?
Yes. You would have to create a new sheet and populate it with the responses yourself. Then you make that sheet available as a web page and share then link with the people filling in the form. You can se and example of this on this link → grumo.com/wfhdashboard
Good Video...I kind of get lost in that Spreedsheet..didnt even know that Google does forms..usefull in any case .
Good and useful. Fantastic
great, this was really helpful and awesome
Thank you! Impressive. greetings
Thanks!
Thank you
Great tutorial, thank you! Went through and got it to work. I'm not well versed on script... I got a lot of responses that say "undefined". I have some longer questions on my form, but they are copied and pasted identically. Some give answers, some don't. Any ideas why?
Hello, do you know how to export the created survey as a PDF? I want to hand it out manually as well. Thanks a lot!
export data to excel and than print as .pdf file
Great tutorial. Thank you it worked perfectly. Could you kindly guide me on how to insert my logo into the script as the signature stamp?
Yes. You need to upload the image to your server and then insert it using an image HTML tag as shown here → www.w3schools.com/tags/tag_img.asp
@@GRUMO gud day can u help me with the script ur example is 4 column that u get in ur excel then it show ing script only 4 if i have more that 4 column in execel how will i enter in cript if jt only show 4
thank you.. i have a question how can i do an email conformation if i have different sections in different languages
HI Suzana, the script shown in this video will automatically send a confirmation email in whichever language you write it on. However, I don't know how could you send it in multiple languages. I guess you could simply write the same confirmation email in several languages and send them all at once. Kind of like how manuals are written in a zillion languages and then you have to flip through countless pages until you find a language you understand.
What does this mean "show link to submit another response"? Does this mean that the person can submit that survey more than once (same email)? Does "response" mean "response to the survey as a whole" or "response to an individual question within the survey"?
It means a link to retake the entire survey from scratch.
thanks for the video. i have a few script error messages. ''Cannot read property "namedValues" from undefined. '' any idea what i'm doing wrong?
Thank you ! Such a great help!
My pleasure!
Hiiii … but what’s if I have a large number of questions in the forms and will your script for form will match it ?
Yes, it should work with any number of questions. The other option is connecting your Google Form with Zapier to avoid having to code anything.
Thanks man! Really appreciate it!
Glad I could help!
Thanks!
Hiya, I worked it all out (Google sheets has changed slightly and 'Apps Script' seems to be where all the code is kept now!). However, I didn't get an email when I tested this. I'm getting a few syntax errors in my script such as this, which may be the cause: 'Syntax error: SyntaxError: Invalid or unexpected token line: 93 file: Code.gs' Any idea how I can solve this?
Hi Rob, Syntax error is that your code is not written properly. You may be missing a close bracket or comma in your code somewhere. Alternatively, these days you can use a tool like Zapier to trigger emails from Google Forms after a submission. Zapier requires no coding.
@@GRUMO Thanks - all really helpful! :)
How to use iPad version of this especially the spreadsheet tool script editor
Can a question have multiple options to select from? I need to ask respondents to choose their preferred brand among five different brands mentioned along with a blank box to mention (if others) for different products. So let say, there will be 10 different products in 10 rows and each respective column will have six options (wherein 5 options are different brand names and one is to be left blank for others)
Amazing! Thnx a lot!
Thank you!
You're welcome!
Thanks
You bet!
can we setup survey google form that accepts multiple times submission of datewise updation of record for over a week activity and saves in excel report.pls share video
You may want to look at a 3rd party tool like Jotform to do that.
Once created the spreadsheet how do you go back to the form? I seem to have missed that step and now stuck. Am a dinosaur and need a step by step. help please!
Go to Tools > Manage Form
how do you create a bit link? It doesn't show us how to get there.
how to add all linear scale responses
This was very helpful. Thank you so much.
i have a question if i may...
i created a survey form with several questions, most of them as "multiple choice" (you can choose between 5 answers).
at the end of each question, after the 5 options, i would like to leave room for free text/notes. for example, if someone chose "disagree", I would like him to be able to write and express why doesn't he agree and to share with me the feedback and comments.
i have seen that I can add "other", but then, when I export the information to the excel file, only the "other" appears while the "option" is not there.
is there any way to have both - 'option' and 'other'?
There is no option for option and other. You could add a new text field to allow for comments for those that selected Other.
@@GRUMO
Thank you very much
Hi, I have a google form posted for more than 24 hours. There have been just 3 responses that have been recorded. People are filling up the form and are getting a confirmation but I am not getting the response. I have tried unlinking the form, using a different browser, incognito etc but to no avail. When I fill up the form in incognito mde, I get the response, what could be the resolution?
Hi Amit, I'm not sure what is causing that error as I've never encountered myself before. If you mean "get response" as in getting a confirmation email, then that email is triggered from the javascript code shown in the tutorial. In that case, the culprit would be the piece of code that sends that email.
Lets say I want to make a survey and ask for age and gender at the start, is it possible to review the responses based on age and gender later? If so, how?
Google Forms display a pie-chart aggregating all responses, so you could see what percentage of responses belong to which age group. If you what to only filter out responses based on age group, you would need to do that inside the Google Sheet where all responses are stored and apply a filter to display results based on the chosen age group. You can search RUclips for how to filter data inside a Google Sheet for more details.
my question is, how to put two languages in question? eg, I want to have English and Malay in every questionnaire. thank you. I hope u could answer it ASAP.
grumomedia yup. I only can put the translation on the description box. And the answers for the questions i only use / .. thank you for your respond!
I didn't know Fred Armisen did tutorials.
if you put file upload button then only google users can fill the form , its a draw back
That's correct. However, it's rare that you would ask users to upload a file on a survey.
Hi, what if I would like two admins to receive the email? How do I insert the other admin's email address in the html? Thank you!
I’m not sure. I think you may enter it next to the first one with a comma.
Hi. I studied your video and I learned a lot. Now, I have something in mind that I can't figure it out. Can you make tuturial on how to sort the responses of a specific individual and automatically create a forder to all the responses of this individual. The spreadsheet contains all the responses of this individual regardless of the date and time he or she submitted his/her responses. Still the host email and the client's email received the same informations. Thank you very much
I'm not sure I understand what you're trying to accomplish. If you want to filter specific data from a spreadsheet you can use the FILTER function in Google Sheets.
In Google form, client that wants to give feedback upload pictures as a part of their positive or negative feedback. thank you
Yes, you can add a file upload field to your Google Form.
The java script address does not work. Do you have another? Thanks.
It works for me. Try again → bit.ly/2gcsngF
After trying to set the triggers I ran into the error -- SyntaxError: Invalid or unexpected token (line 55, file "Code.gs") Any solutions?
Hi Corben, I've never seen that error on any of my scripts so I won't be of any help. I recommend you type the error on as it appears on Google and see if someone already figured out how to fix it.
tysm this helped me out
You're welcome!
How can you add 2 admin emails, so 2 people can get notifications when there are new survey responses?
I don't think you can but you could duplicate the mail send function to send the admin emails twice.
Where i can find the code in e mail notification?
I'm not sure what code you're referring to Bella
I’m trying to have a google form where users can submit wishlist items. Then take those wishlist items and have them come up on a second google form to survey the priority on the captured wishlist items. Can anyone give me some direction on how to accomplish this?
You would need to hire a developer create a script to dynamically create fields inside a Google Form.
How to send questionnaire to recipient's inbox rather than in spam?
Sir please reply, I created Google form on mobile phone, how to access the form again I can't access
Log into your Google Drive from your desktop computer using the same Gmail address you used to create the form on your phone. Then search for the form in Google Drive to open it.
Where did you get the background
please how can i download the javascript file
Hi, can you tell us how to get number of responses?
Yes. Create a new sheet next to the sheet with the form responses. Then enter this formula in one of the cells inside the new sheet → =countif('Form Responses 1'!A2:A,"")
Note: Make sure you use the actual name of the sheet where responses are collected for your specific form.
hello , i have created my page but submit button doesn't show me
The Submit button cannot be deleted so it should be there unless you embedded the form in a separate website and made the height value of the embed code too small. Then, you would need to scroll down to reveal the Submit button. Otherwise it should be there. You can also try a different browser or computer to see if the problem persists.
hello,
Thanks for the great video tutorial. I tried everything you mentioned, but still the recipients
are not getting any response. Clues?
Thanks for your reply.
You need to make sure you allow the submit function trigger to send emails as shown at 19:38
Yea man.
Hey can I get the link to download the JavaScript
I have a problem about create google form, sir
each question must to have 2 response (rating scale; 1 2 3 4 5) following
Ex. Relationship of customer;
Quality of service at present Expected Quality of service
1 2 3 4 5 1 2 3 4 5
1. Relationship to community x x
2. Understanding to customer about status x x
of physical and mental health
help me please,
Best regard
This was killer useful but the notification automation doesnt work no more
@@GRUMO ok will try. thanks
Hi Josh,
I've been using a google sheets Add-On to send my notifications...
it is called maintainapp and you can find it in the GSuite marketplace. Hope this helps.
@@RunBuddyde thank you so much will check it out
How did you save the link, it was not clear on the screen, please help
Does this coding bothers mobile users while filling the responses?
Users don't have to do any coding, they simply reply to the questions in the form you created.
Script Editor option doesn't work for me in Google Sheets. Instead of script editing page I'm directed to a notification that says "Sorry, unable to open the file at this time.
Please check the address and try again." Does anyone have a solution or know why this is happenning?
@FLANDEZ_ JOHN REY yup
Sir how to create submit after redirect form using google webapp script
You can't create a redirect using the Google script. But you can customize the message that appears upon completing the online form.
How can it analysis the data?
After people submit responses you can see all the data under the responses tab when you edit the form.
I have an error in line 166 that I cannot figure out how do I email you?
Hello i tried to copy and paste the script and just modify the required input field, but the my email said “Cannot read property 'namedValues' of undefined”. No bugs when run the script. Please if anyone can help. Thanks
That usually happens when the field name in your script doesn’t exactly match your form field name
@@GRUMO Already re-check it many time; the field name is correct acxording to the name in spreadsheet. Moreover, no error while it is run/executed.
same problem can you tell me how did you fix it?
your so funneh
I'm getting an error SyntaxError: Unexpected token '
There is no way I can tell where the error comes from without seeing all the code. However, the script works so the error has to come from one of the changes you made to the original script. This could be something related to the HTML message or one of the variable names from one your form input fields.
Grumo Media hi thanks! In your video you only had 4 questions, I had more so I added the additional lines. I continued the steps but when I went to save it that’s the error message I received
Stelliumx3 So the problem is with the new lines. Make sure they are escaped with a backslash symbol or the code won’t compile.
Grumo Media hi, so I started over. When the excel is created I see additional columns that I don’t have in my questions?
Grumo Media I was able to add the additional lines. Where am I grabbing the link to convert into a smaller link?
Where is the BITLINK link
I am trying to send a URL in the email to the client, so they can go back and edit there form once it has been submitting.
I have been able to capture the URL in the spreadsheet, but when it gets emailed the URL is not there just "Click here to edit/add responses: undefined"
Here is the code
html +=
'Email Address: ' + values["Email Address"] + '\
Click here to edit/add responses: ' + values["Edit URL"] + '\
Patient Date of Birth: ' + values["Date of Birth"] + '\
Patient Phone Number: ' + values["Patient Phone"] + '';
any ideas on how to resolve this?
What’s your mother language bro??
Thank you!!