How to create a survey with Google Forms (full tutorial)

  Рет қаралды 411,129

GRUMO

GRUMO

Күн бұрын

Пікірлер: 185
@mavistaratu3357
@mavistaratu3357 3 жыл бұрын
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
@GRUMO 3 жыл бұрын
Thanks!
@floridapctutor
@floridapctutor 4 жыл бұрын
One of the best tutorials I've ever seen on KZbin. Just created my first survey using Google Forms. Thank you.
@GRUMO
@GRUMO 4 жыл бұрын
Thanks Scott!
@johnfoster6155
@johnfoster6155 4 жыл бұрын
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.
@CB_Atl
@CB_Atl 5 жыл бұрын
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_Atl
@CB_Atl 5 жыл бұрын
Thanks again!
@betulo25
@betulo25 Жыл бұрын
Learned that a random space in the survey header can throw off your JavaScript. Thank you, Miguel.
@GRUMO
@GRUMO Жыл бұрын
Cheers!
@arnoldremulta608
@arnoldremulta608 4 жыл бұрын
Thank you.... Wow... All the questions in my mind was answered through your tutorial... God bless
@GRUMO
@GRUMO 4 жыл бұрын
Glad it was helpful!
@gemalynnovelo6396
@gemalynnovelo6396 5 жыл бұрын
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
@GRUMO 4 жыл бұрын
Glad to hear my video was helpful for your assignment!
@symcny6001
@symcny6001 2 жыл бұрын
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
@GRUMO 2 жыл бұрын
Now I’d recommend you use Zapier to trigger emails from Google Forms.
@symcny6001
@symcny6001 2 жыл бұрын
@@GRUMO thank you!
@taha335
@taha335 4 жыл бұрын
thanks, very good description and usefull video
@GRUMO
@GRUMO 4 жыл бұрын
Glad it was helpful!
@TheAHShowVideosTV
@TheAHShowVideosTV 3 жыл бұрын
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
@GRUMO 3 жыл бұрын
My pleasure Anne!
@robcalcutt
@robcalcutt 2 жыл бұрын
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
@GRUMO 2 жыл бұрын
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
@robcalcutt 2 жыл бұрын
@@GRUMO Thanks - all really helpful! :)
@bernardosei1974
@bernardosei1974 3 жыл бұрын
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
@eveshelllindayao3913
@eveshelllindayao3913 3 жыл бұрын
thank you so much.. i am happy that i have learned a lot from this topic...
@GRUMO
@GRUMO 3 жыл бұрын
You’re welcome 😉
@debclark3412
@debclark3412 3 жыл бұрын
Thank you for the great tutorial! Much appreciated!!!
@GRUMO
@GRUMO 3 жыл бұрын
You're welcome!
@alwaysevolve4923
@alwaysevolve4923 2 жыл бұрын
Very helpful!! Thank you!!!
@GRUMO
@GRUMO 2 жыл бұрын
You're welcome!
@antonioelizondo8290
@antonioelizondo8290 6 жыл бұрын
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
@bernardosei1974
@bernardosei1974 3 жыл бұрын
great, this was really helpful and awesome
@ANAAMALY
@ANAAMALY 6 жыл бұрын
This was very useful and easy to follow! I'm up and running with my pre-healing session survey. Thank you.
@stephaniepindar6726
@stephaniepindar6726 3 жыл бұрын
I appreciate the tutorial you provided!!
@florencemallorca7378
@florencemallorca7378 4 жыл бұрын
BRAVO!! GRACIAS SENNNNOR!!!!
@GRUMO
@GRUMO 4 жыл бұрын
Thanks Florence!
@Crayzee109
@Crayzee109 4 жыл бұрын
This was very helpful. Thank you so much.
@ireneogcanete5492
@ireneogcanete5492 4 жыл бұрын
Amazing video... thanks a lot
@GRUMO
@GRUMO 4 жыл бұрын
Glad you liked it Ireneo!
@antonguskov6949
@antonguskov6949 5 жыл бұрын
Thank you for the info! Newer used Google Forms for surveys creating...
@hashtaghitsbytanhaz8468
@hashtaghitsbytanhaz8468 4 жыл бұрын
This is amazing tutorial.. Thanks a lot.. may Allah bless you 💖🌺
@GRUMO
@GRUMO 4 жыл бұрын
You are welcome 😊
@SimonaIonitaEdenCenter
@SimonaIonitaEdenCenter 4 жыл бұрын
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
@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.)
@bonnielarson5860
@bonnielarson5860 2 жыл бұрын
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
@GRUMO 2 жыл бұрын
Thanks for your feedback!
@pacesibiya305
@pacesibiya305 4 жыл бұрын
Bro you are amazing, great video, on point 👌, straight and working perfectly. Thanks bro. Keep it up
@GRUMO
@GRUMO 4 жыл бұрын
Thanks!
@NTDSP
@NTDSP Жыл бұрын
Awesome video! Can you make an updated version for 2023? There is no tools > script area :)
@GRUMO
@GRUMO Жыл бұрын
Thanks, now you can access the script area under Extensions > Apps Script
@hansoninyang7064
@hansoninyang7064 5 жыл бұрын
Thanks for making this video, it really help.
@bkbce_ankitpingol9768
@bkbce_ankitpingol9768 2 жыл бұрын
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
@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.
@arleneencendencia4385
@arleneencendencia4385 4 жыл бұрын
Thank you! Impressive. greetings
@GRUMO
@GRUMO 4 жыл бұрын
Thanks!
@Ladibela
@Ladibela 3 жыл бұрын
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
@GRUMO 3 жыл бұрын
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.
@kanmaolise1921
@kanmaolise1921 6 жыл бұрын
thanks for the video. i have a few script error messages. ''Cannot read property "namedValues" from undefined. '' any idea what i'm doing wrong?
@lethjazzcabales1664
@lethjazzcabales1664 4 жыл бұрын
Thanks man! Really appreciate it!
@GRUMO
@GRUMO 4 жыл бұрын
Glad I could help!
@MynameisJanRed
@MynameisJanRed 4 жыл бұрын
Thank you ! Such a great help!
@GRUMO
@GRUMO 4 жыл бұрын
My pleasure!
@amandeepsinghbassi1600
@amandeepsinghbassi1600 10 ай бұрын
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
@GRUMO 10 ай бұрын
You may want to look at a 3rd party tool like Jotform to do that.
@reeneejackson142
@reeneejackson142 5 жыл бұрын
how do you create a bit link? It doesn't show us how to get there.
@villagenumerique9085
@villagenumerique9085 5 жыл бұрын
thanks for your time and tutorial
@jango1970
@jango1970 3 жыл бұрын
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
@GRUMO 3 жыл бұрын
It means a link to retake the entire survey from scratch.
@hellowmellow534
@hellowmellow534 Жыл бұрын
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
@GRUMO Жыл бұрын
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 KZbin for how to filter data inside a Google Sheet for more details.
@suzanahs9634
@suzanahs9634 4 жыл бұрын
thank you.. i have a question how can i do an email conformation if i have different sections in different languages
@GRUMO
@GRUMO 4 жыл бұрын
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.
@nidhimaheshwari8257
@nidhimaheshwari8257 5 жыл бұрын
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.
@mejerrivera651
@mejerrivera651 5 жыл бұрын
Helll yeahhh... you are very awsome mannn you help me alot with my Research Study
@valentinadaprile104
@valentinadaprile104 2 жыл бұрын
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
@GRUMO 2 жыл бұрын
Go to Tools > Manage Form
@lulwabuheji6327
@lulwabuheji6327 3 жыл бұрын
Where did you get the background
@andylucy7894
@andylucy7894 5 жыл бұрын
how to add all linear scale responses
@stephaniewilliams416
@stephaniewilliams416 5 жыл бұрын
How to use iPad version of this especially the spreadsheet tool script editor
@khushbugoyal9988
@khushbugoyal9988 7 жыл бұрын
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)
@sumanmahato9942
@sumanmahato9942 5 жыл бұрын
Good and useful. Fantastic
@labg27
@labg27 7 жыл бұрын
Very useful gs code. Thanks. In the case of not wanting to get more emails, could we just unlink the form?
@alhadad1979
@alhadad1979 5 жыл бұрын
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?)
@susannalazarus5559
@susannalazarus5559 3 жыл бұрын
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
@GRUMO 3 жыл бұрын
I’m not sure. I think you may enter it next to the first one with a comma.
@sheri7185
@sheri7185 3 жыл бұрын
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
@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.
@ABCTraderABCTrader
@ABCTraderABCTrader 5 жыл бұрын
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
@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
@nesmusic4u
@nesmusic4u 7 жыл бұрын
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
@jancisgem 5 жыл бұрын
export data to excel and than print as .pdf file
@sycfiles6172
@sycfiles6172 4 жыл бұрын
if you put file upload button then only google users can fill the form , its a draw back
@GRUMO
@GRUMO 4 жыл бұрын
That's correct. However, it's rare that you would ask users to upload a file on a survey.
@AmitSingh-cz3pr
@AmitSingh-cz3pr 4 жыл бұрын
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
@GRUMO 4 жыл бұрын
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.
@teachingscience2743
@teachingscience2743 4 жыл бұрын
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
@GRUMO 4 жыл бұрын
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.
@mi_jan
@mi_jan 3 жыл бұрын
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
@GRUMO 3 жыл бұрын
You would need to hire a developer create a script to dynamically create fields inside a Google Form.
@UVSKY
@UVSKY 3 жыл бұрын
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
@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
@UVSKY 3 жыл бұрын
@@GRUMO Thank you very much
@josephorlyespedido302
@josephorlyespedido302 3 жыл бұрын
In Google form, client that wants to give feedback upload pictures as a part of their positive or negative feedback. thank you
@GRUMO
@GRUMO 3 жыл бұрын
Yes, you can add a file upload field to your Google Form.
@clarissaramirez5142
@clarissaramirez5142 3 жыл бұрын
How can you add 2 admin emails, so 2 people can get notifications when there are new survey responses?
@GRUMO
@GRUMO 3 жыл бұрын
I don't think you can but you could duplicate the mail send function to send the admin emails twice.
@anniemaeaguilar9621
@anniemaeaguilar9621 3 жыл бұрын
Thank you!
@GRUMO
@GRUMO 3 жыл бұрын
You're welcome!
@guillianjoynavarro6051
@guillianjoynavarro6051 4 жыл бұрын
Thanks a lot
@blagojelukic
@blagojelukic 7 жыл бұрын
Good Video...I kind of get lost in that Spreedsheet..didnt even know that Google does forms..usefull in any case .
@jmayor88
@jmayor88 6 жыл бұрын
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?
@beano775
@beano775 4 жыл бұрын
After trying to set the triggers I ran into the error -- SyntaxError: Invalid or unexpected token (line 55, file "Code.gs") Any solutions?
@GRUMO
@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.
@joneppiartigas6757
@joneppiartigas6757 3 жыл бұрын
Thank you
@sumanmahato9942
@sumanmahato9942 5 жыл бұрын
How to send questionnaire to recipient's inbox rather than in spam?
@aisyahjamin2900
@aisyahjamin2900 6 жыл бұрын
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
@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!
@bellasibhambieinocencio6529
@bellasibhambieinocencio6529 4 жыл бұрын
Where i can find the code in e mail notification?
@GRUMO
@GRUMO 4 жыл бұрын
I'm not sure what code you're referring to Bella
@ogonnaezepue
@ogonnaezepue 6 жыл бұрын
please how can i download the javascript file
@marlacaposselalefac9478
@marlacaposselalefac9478 4 жыл бұрын
The java script address does not work. Do you have another? Thanks.
@GRUMO
@GRUMO 4 жыл бұрын
It works for me. Try again → bit.ly/2gcsngF
@Elitethoughts1
@Elitethoughts1 2 жыл бұрын
Sir please reply, I created Google form on mobile phone, how to access the form again I can't access
@GRUMO
@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.
@martinwangila2801
@martinwangila2801 3 жыл бұрын
Hey can I get the link to download the JavaScript
@danea_j
@danea_j 5 жыл бұрын
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
@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
@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
@ShanShan-hb7re
@ShanShan-hb7re 3 жыл бұрын
How did you save the link, it was not clear on the screen, please help
@shreyapatil3995
@shreyapatil3995 3 жыл бұрын
Does this coding bothers mobile users while filling the responses?
@GRUMO
@GRUMO 3 жыл бұрын
Users don't have to do any coding, they simply reply to the questions in the form you created.
@aldaiphizer
@aldaiphizer 6 жыл бұрын
Amazing! Thnx a lot!
@noriakarimi7432
@noriakarimi7432 Жыл бұрын
How can it analysis the data?
@GRUMO
@GRUMO Жыл бұрын
After people submit responses you can see all the data under the responses tab when you edit the form.
@megumiokeie9665
@megumiokeie9665 4 жыл бұрын
tysm this helped me out
@GRUMO
@GRUMO 4 жыл бұрын
You're welcome!
@juanmorris6006
@juanmorris6006 3 жыл бұрын
Thanks
@GRUMO
@GRUMO 3 жыл бұрын
You bet!
@someboxes2972
@someboxes2972 6 жыл бұрын
Thanks!
@nancia1424
@nancia1424 3 жыл бұрын
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
@nancia1424 3 жыл бұрын
@FLANDEZ_ JOHN REY yup
@mayursawant7992
@mayursawant7992 2 жыл бұрын
Sir how to create submit after redirect form using google webapp script
@GRUMO
@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.
@pennybelcourt3158
@pennybelcourt3158 7 жыл бұрын
I have an error in line 166 that I cannot figure out how do I email you?
@LofiTushar75
@LofiTushar75 6 жыл бұрын
Hi, can you tell us how to get number of responses?
@GRUMO
@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.
@martambasitumorang9936
@martambasitumorang9936 3 жыл бұрын
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
@GRUMO 3 жыл бұрын
That usually happens when the field name in your script doesn’t exactly match your form field name
@martambasitumorang9936
@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
@faiyazrabby9534 3 жыл бұрын
same problem can you tell me how did you fix it?
@makaizakeesee2814
@makaizakeesee2814 7 жыл бұрын
Thank you!!
@jeromehealy
@jeromehealy 6 жыл бұрын
I didn't know Fred Armisen did tutorials.
@s.muqarabjamil3257
@s.muqarabjamil3257 4 жыл бұрын
hello , i have created my page but submit button doesn't show me
@GRUMO
@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.
@stelliumX5
@stelliumX5 4 жыл бұрын
I'm getting an error SyntaxError: Unexpected token '
@GRUMO
@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
@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
@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
@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
@stelliumX5 4 жыл бұрын
Grumo Media I was able to add the additional lines. Where am I grabbing the link to convert into a smaller link?
@prateepkankhwao3319
@prateepkankhwao3319 3 жыл бұрын
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
@tonyabiatmeh4042
@tonyabiatmeh4042 6 жыл бұрын
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
@GRUMO 4 жыл бұрын
You need to make sure you allow the submit function trigger to send emails as shown at 19:38
@joshfernandez6662
@joshfernandez6662 5 жыл бұрын
This was killer useful but the notification automation doesnt work no more
@joshfernandez6662
@joshfernandez6662 5 жыл бұрын
@@GRUMO ok will try. thanks
@RunBuddyde
@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
@joshfernandez6662 4 жыл бұрын
@@RunBuddyde thank you so much will check it out
@aimalakakhail5547
@aimalakakhail5547 3 жыл бұрын
Where is the BITLINK link
@souravray7448
@souravray7448 3 жыл бұрын
Yea man.
@rafaeljohnrivera1600
@rafaeljohnrivera1600 4 жыл бұрын
your so funneh
@hayleyR6
@hayleyR6 6 жыл бұрын
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?
@tedanoch
@tedanoch 6 жыл бұрын
What’s your mother language bro??
@marizjaynos128
@marizjaynos128 3 жыл бұрын
Thanks you very much!
@GRUMO
@GRUMO 3 жыл бұрын
You're welcome!
Google Forms - Creating a Research Survey
13:04
Joshua Johnson
Рет қаралды 166 М.
Google Forms Beginner Tutorial
1:05:52
Learnit Training
Рет қаралды 36 М.
Une nouvelle voiture pour Noël 🥹
00:28
Nicocapone
Рет қаралды 9 МЛН
Леон киллер и Оля Полякова 😹
00:42
Канал Смеха
Рет қаралды 4,7 МЛН
Don’t Use Google Forms Without These FREE Add-Ons!
16:03
Simpletivity
Рет қаралды 70 М.
Google Forms Tutorial
29:15
Kevin Stratvert
Рет қаралды 1,3 МЛН
How to Create a Survey Using Google Forms
14:12
Simon Sez IT
Рет қаралды 227 М.
How to Create a Google Forms Quiz | Self Grading and Imports into Google Classroom
14:06
Google Forms - Drop Down List from Spreadsheet Using Apps Script
34:39
Learn Google Sheets & Excel Spreadsheets
Рет қаралды 448 М.
5 Google Forms Tips Every User Should Know!
11:55
Simpletivity
Рет қаралды 352 М.
Create Online Survey Questionnaire Using Google Form
11:07
Platform for Research & Development
Рет қаралды 31 М.
How to use Google Forms - Tutorial for Beginners
17:47
Simpletivity
Рет қаралды 2,2 МЛН