Thanks You so much! This is a life saver and couldnt find this answer anywhere

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!!

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!

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.

Hey David, do we need to run setUpTrigger() again when we have already created the trigger? Thank you.

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 ).

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.

Thank you so much! You are amazing! Question, how could you make this script include information from the linked spreadsheet in the email?

@yousufidris7311

2 жыл бұрын

I believe one way you could do that is adding the spreadsheet URL to the body

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.

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).

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 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

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

Hello there. How to automatically update title description part from google spreadsheet in google forms with google script.

How do you pass the submitted form to the function?

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

Exception: Unexpected error while getting the method or property create on object ScriptApp.FormTriggerBuilder. setupTrigger

@FRAN-vd9rl

2 жыл бұрын

hi, i'm getting the exact same error.

@christianarnold2676

2 жыл бұрын

same

@christianarnold2676

2 жыл бұрын

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!

Man, good job on cover page. But it's better you learn zoom in your script editor.

@DavidWeissProgramming

4 жыл бұрын

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! :)

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.

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 David, I followed every step exactly. However, I can't get anything to log under event (e). Any idea what I might be missing?

@DavidWeissProgramming

4 жыл бұрын

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?

@girassolbrasilenergiasolar155

3 жыл бұрын

you could just add the url on the message that appears after you submit the form, on the google forms app itself

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?

@felrickson

4 жыл бұрын

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

@FerreraNaig

3 жыл бұрын

@@felrickson How do i check that? I seted up a trigger Just like his and i am recieving 2 e-mails Just like him.

I wrote exactly the codes step by step with you and it didnt work! The email hasnt sent 😭 why? Please help

@DavidWeissProgramming

2 жыл бұрын

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!

Google submit open facebook

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