Submit a Google Form and Auto Email Responses to Admin and Form User
Вставка
- Опубліковано 18 вер 2024
- 📊 Free Workbooks: www.excelvbais...
🥷Join Excel Ninja Pro: www.excelvbais... Months FREE On Annual Plan Auto Applied)
🥷Excel Ninjas FB Group: www.excelvbais... (Free downloads, Trainings, Live Q&A and more)
Walkthrough of making a google form, adding the script to auto-email and setting the Form Submit trigger to enable this. Then all submissions will flag you in your inbox as well as the submitter's inbox. This email can contain some or all of the form info. Check it out!
Fantastic Developer Tools:
🔒 Transform Any Excel File Into A Locked EXE: www.excelvbais... (25% off with code ‘25OFF’)
🟡 Create Custom Installers: www.excelvbais...
👋 Business Inquiries, Consulting, Comments, etc: www.excelvbais...
Can't believe this isn't native functionality. Thanks for vid.
This is great. Thanks for sharing this. I have to try using it more often myself for the many different types of documents that I have to create.
i have been looking for this forever. thanks so much.
Hi I haven't Found an option in Spreadsheet Incert>script its missing or what what is another way to do the same..
thanks for your detailed instructions...
Nice video and good solution for detailed email requirements. If you however just want a simple email to alert you that someone has submitted a response then a much quicker solution can be created by adding a very short script to the form itself rather than the spreadsheet.
Within the form editor click Tools > Script manager, then click New. Select "Blank Project". Rename the script to something sensible, then rename the function to something like "emailResponse". Within the curly braces enter:
var form = FormApp.getActiveForm();
var responses = form.getResponses();
var formURL = responses[responses.length - 1].getEditResponseUrl();
var recipient = "email address of recipient";
var subject = "Form abc has been submitted";
var body = "Test form abc has been submitted, click the following URL to view the response.
" + formURL;
MailApp.sendEmail(recipient, subject, body);
Next run the script to authorise it to use your email address and form etc, do this by selecting the function from the above drop down box and clicking the play button.
Finally create a project trigger via the "Resources" drop down menu to run the function every time the form is successfully submitted.
If your form captures the email of the submitter then as an extra you could always add the following line to your code and append the body string with that as well, you then have quick visibility of who submitted the form without having to open it or the spreadsheet.
var respondentEmail = responses[responses.length - 1].getRespondentEmail();
You can obviously code the email to include a lot more information such as the individual responses, but for those requirements it's probably simpler to just follow this video unless you really need detailed customisation.
Hope that helps.
Samo
Thanks for the info, Richard!!
hi bro..can u teach me how can i add more perimeter. For example i insert another column and the report also appear at email.
this is not up to date, there is no option under insert to insert a script
It seems the Insert - Script function no longer exists?
+Anfernee Chansamooth
Tools/Script Editor
What have you done so that the Google Forms remember your name from time to time so that you can re-use it when filling in a new form?
Well damn good job , I like the way you explain it, but my question is if I create a Google form I want to create as a format so when I send it to you I don’t need to get a respond you can use it however you want it you can send it to anybody as it’s coming from you is it possible
How do I create a form that forwards another form to an email address a respondent submits.
this is to enable peer review, where a responded would input a reviewers email address
Thanks Dan !!!
Very welcome Prince!
Does anyone know that do I have to pay for it after using a certain time ??
Please my form does not have script under the insert option..what do i do
Hi, I managed to get the answers to my email but they show up in random order each time. Any idea how I can fix this?
Insert->Script doesn't exist....replaced with add-ons which no longer carries FormEmailer. Also, when I manually copy paste FormEmailer script code, it works a few days and then is no longer available for that specific spreadsheet. Need another work around or a different script. Thanks!
Jim Hitchcock Sadly, google is changing things all the time as well as policies. Thanks for the info!
Dan
ExcelVbaIsFun Just saw there is a new addon by google called "Form notification". Couldn't get it to work but you might be able to.
Can I do d-list email?
Im using the formemailer for months. why cant i install it on new Google forms? i can't find it in the add-on which is the new way to install scripts in the form... any idea?
There are directions somewhere in Google. You can have to copy and paste the script from an old form. It works on the new forms.
Can you do an update?
google has addons now is there another way
My google forms page looks nothing like this!
Thanks very much bro, that was a great advice. Bless you.
I might add on something that at the time I wrote this comment, FormEmailer was not on the Add-on tab that you can see in the excel sheet (this has replaced the Insert>Script). This is because a newer version of it was getting approved by Google. So, instead you can go to script editor and build up your own FormEmailer. The guy who developed it was nice enough to have the script on the web. Follow his instructions, that is with following the instructions of this video too and you can not go wrong. Watch the video to the end as well.
sites.google.com/site/formemailer/updates
I found a link to install it from script gallery, sites.google.com/site/formemailer/getstarted follow those instructions