Hello, my name is Maurílio and I live in Brazil. I watched this video of yours, trying to solve a problem of mine and I really liked it!! I noticed in this video that at 4 minutes and 13 seconds you managed to create a drop-down list where you filter the results as you type in the text field. Do you have a video that shows how to do this? Thank you very much!!
Thanks You so much! This is a life saver and couldnt find this answer anywhere
7 місяців тому
Hello, how do I redirect the lead to a website after they fill out the form? I don't want to put the link so he has to click. I would like it to be automatically redirected to the website when pressing the submission button. It's possible? How to do this? Would you help me? Tks
Hey is there a way to speak to you about my current script I'm pulling my hair over I need some guidance and came across your videos I think I'm getting there with it but something throwing me off or not right.
Hi, I have arrayformula in a column related to the data entered b seny the customer but when it picks data from spreadsheet it shows " undefined " in mail body. i want a delay in sending a mail so that data can be picked correctly from spreadsheet
Hey.. Please make a video on "automatic collect current location of the user whenever he/she clicks submit button in google form" Responses will be multiple not the single one.
Thank you for your feedback! It's a delicate balance between zooming in too far where none of the contextual code is displayed and zooming out too far where it's hard to see :/ With these already published videos, I'd recommend enlarging the text by going full screen! :)
This comment helped - Hi Rahul! Hm, I'm not quite sure since I can't see your code / Form. However, something that jumps to mind could be that you don't have the "collect email addresses" box checked in the Form settings. In order to use the method getRespondentEmail, you'll have to collect their email. To do that, go to your Form, click on the gear icon on the upper right-hand side of the screen, and click "collect email addresses". Likewise, if it's not already checked, click on "Edit after submit" under the "Respondents Can: " heading. Let me know if this helped!
Create a trigger with submit form + time is it possible? So when the participant clicks submit, a spreadsheet formula will be created, so there needs to be a little extra time since submitting, maybe 5 seconds.
Hey David, I really need your help regarding an app script, where users submit their preferances for some items, that preference is used to sort an existing sheet and on form submit the user can get the link of a newly created google sheet ( where the sorted list according to their preference is available ).
I David, tks for your video. Is it possible to run a script when an email is received as a trigger ? I.e: Send by email a client registration and after I receive the email, the script will register the cliente automatically..
Hi, I am a newbie in google app script. I would like to create a script where it changes the filename of uploaded files after I clicked submit. The filename will base on the response (Ex. name_group_datesubmit).
Hi Rahul! Hm, I'm not quite sure since I can't see your code / Form. However, something that jumps to mind could be that you don't have the "collect email addresses" box checked in the Form settings. In order to use the method getRespondentEmail, you'll have to collect their email. To do that, go to your Form, click on the gear icon on the upper right-hand side of the screen, and click "collect email addresses". Likewise, if it's not already checked, click on "Edit after submit" under the "Respondents Can: " heading. Let me know if this helped!
Hii, I am not a techie, but I think I might have some idea as too how did you receive 2 emails.. I tried the same trick and ran the code for a few times and noticed something, if i run the code for a few time, the code will automatically generate a trigger with each run. So, if i run the code for 5 time, the code will generate 5 triggers and send the person 5 email.. I tried and ran the form with trigger for 20 times trying new things and code and I received 20 emails 😅😅... So, now I am looking for a way in which the trigger is only set one time and not when the form is submitted. So, if anyone has any idea as too how do i change the first part (the trigger loop) so that it only runs one time not thousands, please let me know.. Thank you in advance..
Hi K-Lead! Sorry to hear it didn't work. Let try and debug together! First off, are you getting any errors when you run the "setUpTrigger" function? Be sure to check the "executions" tab on the left hand side of the screen too, to make sure your function is being run how you'd expect it to. After running the function, confirm your trigger has been set up by going to the "triggers" tab on the left hand side. If your trigger is there and its set to fire "sendConfirmationEmail" then it should be good to go. Finally, if you are using the same "sendConfirmationEmail" as me, make sure the Form is set to require email addresses and allows response editing. You can switch these two settings on by first going to your Form > Settings > Responses > and switch on "Collect email addresses" and "Allow response editing" Hopefully this helped! If you have any other questions, feel free to reply back!
every time you run the "setup trigger" function, a new trigger gets added on "my triggers" list, just check that there is only one running for each script you have
This appears to be pretty useless. As soon as you add this code to a script file, you will get the "cannot-call-spreadsheetapp-getui-from-this-context-error". So if you want to add this to code that uses ui, even in other functions, then you are out of luck. What a waste of time.
Good but useless. Please make a video on how to edit the recorded responses in Google sheet. The thing that you have shown is already present within Google Form
Hello, my name is Maurílio and I live in Brazil. I watched this video of yours, trying to solve a problem of mine and I really liked it!! I noticed in this video that at 4 minutes and 13 seconds you managed to create a drop-down list where you filter the results as you type in the text field. Do you have a video that shows how to do this? Thank you very much!!
Thanks You so much! This is a life saver and couldnt find this answer anywhere
Hello, how do I redirect the lead to a website after they fill out the form? I don't want to put the link so he has to click. I would like it to be automatically redirected to the website when pressing the submission button. It's possible? How to do this? Would you help me? Tks
Hey is there a way to speak to you about my current script I'm pulling my hair over I need some guidance and came across your videos I think I'm getting there with it but something throwing me off or not right.
Thank you so much! You are amazing! Question, how could you make this script include information from the linked spreadsheet in the email?
How would the forSpreadsheet option work? I want to an email to be sent out whenever a new row record is made in Google sheet.
Hi, I have arrayformula in a column related to the data entered b seny the customer but when it picks data from spreadsheet it shows " undefined " in mail body. i want a delay in sending a mail so that data can be picked correctly from spreadsheet
Hey.. Please make a video on "automatic collect current location of the user whenever he/she clicks submit button in google form"
Responses will be multiple not the single one.
Man, good job on cover page. But it's better you learn zoom in your script editor.
Thank you for your feedback! It's a delicate balance between zooming in too far where none of the contextual code is displayed and zooming out too far where it's hard to see :/ With these already published videos, I'd recommend enlarging the text by going full screen! :)
Exception: Unexpected error while getting the method or property create on object ScriptApp.FormTriggerBuilder.
setupTrigger
hi, i'm getting the exact same error.
same
This comment helped - Hi Rahul! Hm, I'm not quite sure since I can't see your code / Form. However, something that jumps to mind could be that you don't have the "collect email addresses" box checked in the Form settings. In order to use the method getRespondentEmail, you'll have to collect their email. To do that, go to your Form, click on the gear icon on the upper right-hand side of the screen, and click "collect email addresses". Likewise, if it's not already checked, click on "Edit after submit" under the "Respondents Can: " heading. Let me know if this helped!
Create a trigger with submit form + time is it possible?
So when the participant clicks submit, a spreadsheet formula will be created, so there needs to be a little extra time since submitting, maybe 5 seconds.
Hello there. How to automatically update title description part from google spreadsheet in google forms with google script.
Hey David, do we need to run setUpTrigger() again when we have already created the trigger? Thank you.
Hi Mr. David. Do you have an idea on how to close the google form window after submitting answers? Thanks in advance for the response!
Hey David, I really need your help regarding an app script, where users submit their preferances for some items, that preference is used to sort an existing sheet and on form submit the user can get the link of a newly created google sheet ( where the sorted list according to their preference is available ).
I David, tks for your video. Is it possible to run a script when an email is received as a trigger ? I.e: Send by email a client registration and after I receive the email, the script will register the cliente automatically..
Dear bro.
I want my form response (google sheet) get the responder address when they submit the form. Hope you help for this
Is there any way to reload the page via script.
In case I'm using Google slide
Hi, I am a newbie in google app script. I would like to create a script where it changes the filename of uploaded files after I clicked submit. The filename will base on the response (Ex. name_group_datesubmit).
sir can you teach me how to trap the duplicate entry in google form.. if you ENTER a code, no one can ENTER again. thanks
Hey David, I followed every step exactly. However, I can't get anything to log under event (e). Any idea what I might be missing?
Hi Rahul! Hm, I'm not quite sure since I can't see your code / Form. However, something that jumps to mind could be that you don't have the "collect email addresses" box checked in the Form settings. In order to use the method getRespondentEmail, you'll have to collect their email. To do that, go to your Form, click on the gear icon on the upper right-hand side of the screen, and click "collect email addresses". Likewise, if it's not already checked, click on "Edit after submit" under the "Respondents Can: " heading. Let me know if this helped!
Please do you have a tutorial on how to make submit button on google forms redirect to another URL?
you could just add the url on the message that appears after you submit the form, on the google forms app itself
Hii, I am not a techie, but I think I might have some idea as too how did you receive 2 emails..
I tried the same trick and ran the code for a few times and noticed something, if i run the code for a few time, the code will automatically generate a trigger with each run.
So, if i run the code for 5 time, the code will generate 5 triggers and send the person 5 email..
I tried and ran the form with trigger for 20 times trying new things and code and I received 20 emails 😅😅...
So, now I am looking for a way in which the trigger is only set one time and not when the form is submitted.
So, if anyone has any idea as too how do i change the first part (the trigger loop) so that it only runs one time not thousands, please let me know..
Thank you in advance..
How do you pass the submitted form to the function?
I wrote exactly the codes step by step with you and it didnt work! The email hasnt sent 😭 why? Please help
Hi K-Lead! Sorry to hear it didn't work. Let try and debug together!
First off, are you getting any errors when you run the "setUpTrigger" function? Be sure to check the "executions" tab on the left hand side of the screen too, to make sure your function is being run how you'd expect it to.
After running the function, confirm your trigger has been set up by going to the "triggers" tab on the left hand side. If your trigger is there and its set to fire "sendConfirmationEmail" then it should be good to go.
Finally, if you are using the same "sendConfirmationEmail" as me, make sure the Form is set to require email addresses and allows response editing. You can switch these two settings on by first going to your Form > Settings > Responses > and switch on "Collect email addresses" and "Allow response editing"
Hopefully this helped! If you have any other questions, feel free to reply back!
Hi David! I'm also getting multiple (4) emails sent when I run the trigger and I'm not sure why. How did you correct that problem?
every time you run the "setup trigger" function, a new trigger gets added on "my triggers" list, just check that there is only one running for each script you have
@@felrickson How do i check that? I seted up a trigger Just like his and i am recieving 2 e-mails Just like him.
This appears to be pretty useless. As soon as you add this code to a script file, you will get the "cannot-call-spreadsheetapp-getui-from-this-context-error". So if you want to add this to code that uses ui, even in other functions, then you are out of luck. What a waste of time.
Google submit open facebook
Good but useless. Please make a video on how to edit the recorded responses in Google sheet.
The thing that you have shown is already present within Google Form