I used Google Forms to create a form for people to register for an event,
by entering their name and email address.
I would like to set it up so that
when a person enters his name and email,
the Google Form will automatically send an e-mail to that e-mail address,
to acknowledge that we have received a submission from this person.
Is this possible?
Best Answer
Please note: Under
Settings
-->Presentation
one can set the Confirmation message that will only be shown on the browser screen upon submission.What you ask for is that:
You will find that there is a number of ways to make this possible.
Using a script
For your convenience I have created a form including but not limited to the fields
Event
,FirstName
,LastName
,Email
. Please have a look at it.To write the script we will use the Script Editor on the answers spreadsheet linked to the form (not the script editor in the form).
Tools
->Script editor...
A really minimal code:
These very few lines of code are enough for a basic reply.
The
e.values
2, 5 and 1 correspond to the columns on the spreadsheet where the answers are submitted. Keep in mind that the numbering for the columns start with 0. Zero being the column reserved for the timestamp.The code being column depended may be a bit difficult to understand, especially when we have more than a few answer fields.
On the other hand you may want to use a more advanced but also user friendly code. The following code does not depend on the columns numbers but on the headers of the spreadsheet (questions of the form).
Since the code is easier to follow we can make it so we get a more personalized message enriched with more fields.
A more user friendly, personal, enriched code
The above code is scalable and very flexible. You can easily add or omit variables, send copies to other emails or to yourself for debugging, append the answers and in general create a more personalized message for the submitter.
Still. If you simply do not want to code any, there is an alternative method.
Using an add-on
A number of add-ons can be found in the Google Web Store.