How to create a survey with Google Forms (full tutorial)
Тәжірибелік нұсқаулар және стиль
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: kzread.info...
Пікірлер: 185
Learned that a random space in the survey header can throw off your JavaScript. Thank you, Miguel.
@GRUMO
10 ай бұрын
Cheers!
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!!!
@GRUMO
2 жыл бұрын
Thanks!
Thank you for the info! Newer used Google Forms for surveys creating...
This was very helpful. Thank you so much.
Thank you much. This video was very thoroughly & your instruction took the guessing game out by showing a step-by-step formula. YOU ROCK!
@GRUMO
3 жыл бұрын
My pleasure Anne!
This was very useful and easy to follow! I'm up and running with my pre-healing session survey. Thank you.
One of the best tutorials I've ever seen on KZread. Just created my first survey using Google Forms. Thank you.
@GRUMO
3 жыл бұрын
Thanks Scott!
@johnfoster6155
3 жыл бұрын
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!
@CB-es6rs
5 жыл бұрын
Thanks again!
I appreciate the tutorial you provided!!
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 for making this video, it really help.
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!"🌸
@GRUMO
4 жыл бұрын
Glad to hear my video was helpful for your assignment!
How to use iPad version of this especially the spreadsheet tool script editor
Amazing! Thnx a lot!
Helll yeahhh... you are very awsome mannn you help me alot with my Research Study
Thank you!!
Thank you.... Wow... All the questions in my mind was answered through your tutorial... God bless
@GRUMO
4 жыл бұрын
Glad it was helpful!
Thank you for the great tutorial! Much appreciated!!!
@GRUMO
2 жыл бұрын
You're welcome!
Thanks man! Really appreciate it!
@GRUMO
4 жыл бұрын
Glad I could help!
thanks for your time and tutorial
Thanks!
Thank you ! Such a great help!
@GRUMO
4 жыл бұрын
My pleasure!
Good and useful. Fantastic
great, this was really helpful and awesome
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)
Very helpful!! Thank you!!!
@GRUMO
Жыл бұрын
You're welcome!
Bro you are amazing, great video, on point 👌, straight and working perfectly. Thanks bro. Keep it up
@GRUMO
3 жыл бұрын
Thanks!
Very useful gs code. Thanks. In the case of not wanting to get more emails, could we just unlink the form?
Thanks you very much!
@GRUMO
3 жыл бұрын
You're welcome!
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?)
BRAVO!! GRACIAS SENNNNOR!!!!
@GRUMO
4 жыл бұрын
Thanks Florence!
thanks for the video. i have a few script error messages. ''Cannot read property "namedValues" from undefined. '' any idea what i'm doing wrong?
Thanks a lot
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!
@jancisgem
4 жыл бұрын
export data to excel and than print as .pdf file
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
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?
thank you so much.. i am happy that i have learned a lot from this topic...
@GRUMO
3 жыл бұрын
You’re welcome 😉
thanks, very good description and usefull video
@GRUMO
4 жыл бұрын
Glad it was helpful!
This is amazing tutorial.. Thanks a lot.. may Allah bless you 💖🌺
@GRUMO
3 жыл бұрын
You are welcome 😊
Good Video...I kind of get lost in that Spreedsheet..didnt even know that Google does forms..usefull in any case .
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?
@GRUMO
4 жыл бұрын
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.)
Amazing video... thanks a lot
@GRUMO
4 жыл бұрын
Glad you liked it Ireneo!
Thank you!
@GRUMO
3 жыл бұрын
You're welcome!
Thank you! Impressive. greetings
@GRUMO
3 жыл бұрын
Thanks!
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
@GRUMO
2 жыл бұрын
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.
I have an error in line 166 that I cannot figure out how do I email you?
how do you create a bit link? It doesn't show us how to get there.
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.
how to add all linear scale responses
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.
@GRUMO
Жыл бұрын
Thanks for your feedback!
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).
@GRUMO
2 жыл бұрын
Now I’d recommend you use Zapier to trigger emails from Google Forms.
@symcny6001
2 жыл бұрын
@@GRUMO thank you!
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?
@GRUMO
4 жыл бұрын
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
After trying to set the triggers I ran into the error -- SyntaxError: Invalid or unexpected token (line 55, file "Code.gs") Any solutions?
@GRUMO
4 жыл бұрын
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.
Hiiii … but what’s if I have a large number of questions in the forms and will your script for form will match it ?
@GRUMO
2 жыл бұрын
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.
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?
@GRUMO
Жыл бұрын
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.
@robcalcutt
Жыл бұрын
@@GRUMO Thanks - all really helpful! :)
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?
@GRUMO
3 жыл бұрын
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.
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'?
@GRUMO
3 жыл бұрын
There is no option for option and other. You could add a new text field to allow for comments for those that selected Other.
@UVSKY
3 жыл бұрын
@@GRUMO Thank you very much
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!
@GRUMO
Жыл бұрын
Go to Tools > Manage Form
Thanks
@GRUMO
2 жыл бұрын
You bet!
I didn't know Fred Armisen did tutorials.
Awesome video! Can you make an updated version for 2023? There is no tools > script area :)
@GRUMO
Жыл бұрын
Thanks, now you can access the script area under Extensions > Apps Script
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?
@GRUMO
3 жыл бұрын
You would need to hire a developer create a script to dynamically create fields inside a Google Form.
error message due to long questions list how can i save in this case?
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?
@GRUMO
4 жыл бұрын
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
@catherinepascua1377
3 жыл бұрын
@@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
@GRUMO
3 жыл бұрын
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"?
@GRUMO
2 жыл бұрын
It means a link to retake the entire survey from scratch.
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?
@GRUMO
9 ай бұрын
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 KZread for how to filter data inside a Google Sheet for more details.
please how can i download the javascript file
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
@GRUMO
4 ай бұрын
You may want to look at a 3rd party tool like Jotform to do that.
Where did you get the background
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
@GRUMO
3 жыл бұрын
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.
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.
@aisyahjamin2900
6 жыл бұрын
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!
How did you save the link, it was not clear on the screen, please help
tysm this helped me out
@GRUMO
3 жыл бұрын
You're welcome!
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!
@GRUMO
2 жыл бұрын
I’m not sure. I think you may enter it next to the first one with a comma.
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.
@GRUMO
4 жыл бұрын
You need to make sure you allow the submit function trigger to send emails as shown at 19:38
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?
@GRUMO
3 жыл бұрын
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.
How to send questionnaire to recipient's inbox rather than in spam?
Hey can I get the link to download the JavaScript
How can you add 2 admin emails, so 2 people can get notifications when there are new survey responses?
@GRUMO
3 жыл бұрын
I don't think you can but you could duplicate the mail send function to send the admin emails twice.
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?
@nancia1424
3 жыл бұрын
@FLANDEZ_ JOHN REY yup
if you put file upload button then only google users can fill the form , its a draw back
@GRUMO
4 жыл бұрын
That's correct. However, it's rare that you would ask users to upload a file on a survey.
Yea man.
The java script address does not work. Do you have another? Thanks.
@GRUMO
4 жыл бұрын
It works for me. Try again → bit.ly/2gcsngF
Sir please reply, I created Google form on mobile phone, how to access the form again I can't access
@GRUMO
2 жыл бұрын
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.
In Google form, client that wants to give feedback upload pictures as a part of their positive or negative feedback. thank you
@GRUMO
2 жыл бұрын
Yes, you can add a file upload field to your Google Form.
Does this coding bothers mobile users while filling the responses?
@GRUMO
2 жыл бұрын
Users don't have to do any coding, they simply reply to the questions in the form you created.
Where i can find the code in e mail notification?
@GRUMO
4 жыл бұрын
I'm not sure what code you're referring to Bella
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
@GRUMO
3 жыл бұрын
That usually happens when the field name in your script doesn’t exactly match your form field name
@martambasitumorang9936
3 жыл бұрын
@@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.
@faiyazrabby9534
3 жыл бұрын
same problem can you tell me how did you fix it?
hello , i have created my page but submit button doesn't show me
@GRUMO
4 жыл бұрын
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.
Sir how to create submit after redirect form using google webapp script
@GRUMO
2 жыл бұрын
You can't create a redirect using the Google script. But you can customize the message that appears upon completing the online form.
Hi, can you tell us how to get number of responses?
@GRUMO
4 жыл бұрын
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.
How can it analysis the data?
@GRUMO
Жыл бұрын
After people submit responses you can see all the data under the responses tab when you edit the form.
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
Where is the BITLINK link
your so funneh
This was killer useful but the notification automation doesnt work no more
@joshfernandez6662
4 жыл бұрын
@@GRUMO ok will try. thanks
@RunBuddyde
4 жыл бұрын
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.
@joshfernandez6662
4 жыл бұрын
@@RunBuddyde thank you so much will check it out
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?
I'm getting an error SyntaxError: Unexpected token '
@GRUMO
4 жыл бұрын
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.
@stelliumX5
4 жыл бұрын
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
@GRUMO
4 жыл бұрын
Stelliumx3 So the problem is with the new lines. Make sure they are escaped with a backslash symbol or the code won’t compile.
@stelliumX5
4 жыл бұрын
Grumo Media hi, so I started over. When the excel is created I see additional columns that I don’t have in my questions?
@stelliumX5
4 жыл бұрын
Grumo Media I was able to add the additional lines. Where am I grabbing the link to convert into a smaller link?