Actually this article is a follow-up article from the previous article that discusses how to enable email notifications google form into 2 or more email accounts, in this article we will try to discuss about How To Make Email Google notification form in HTML format.
Google form is one of the tools an alternative to create an online form-based web quickly and easily, this tool apart is able to present an interface that can be operated with ease to make form or online form, turns tool is also equipped with a custom script that can be involved to support the weakness of interfacial google form.
Indeed, if only relying on the design alone is not much that can be done by google form, barangkai only able to make an appearance only as a medium for data input, but with the google script google form able to be set in such a way that we can use as needed dynamically.
one function google script for google google form is to make email notification where the contents of the emails can be set and design as desired.
the email will function when there are users who perform data input or submit the data via the online form google form, whenever responder finished entering data via the form google form , then an email will be sent automatically, either to email responder (the input data) or email for a party that serves the form.
With the notification via automated email, online form google Gorm would be more interactive so that any information submitted new data that could be? identified quickly.
the contents of the email in plain text format, it will only show the email message in the form of writings without any decoration at all, purely in the form of writings.
while the contents of the email in HTML format, will is able to display images, text color, text in bold and other formats as well as a web page display of colorful images and various forms of writing.
Through this article we will try to make the notification email to form gogle form in html format, using google script for google form.
for this case, I think you've understood how to create a form in google form, if you happen to do not understand, you can take the time to read the previous article about making guide online form with google form.
The following step-lagkah make the notification email google form in HTML format:
Step # 1:
Sign in to your google account your drive, to create an online form you .
to this case once again you I think is already understand how to create a form google form, as well know what a google spreadsheet form.
for practice, first please create a form, as shown below this:
Form the above will result in the spreadsheet automatically, more or less will look like the image below:
Step # 2:
enable Script editor via your spreadsheet data form
Please enable your spreadsheet data, after an active spreadsheet, click the Tools menu>? Script Editor ..., looks like the image below:
Step # 3
In the script editor that is already open, please you enter the following script:
Please replace the text in red example@gmail.com with your email that you will use to receive notifications whenever there are doing submit the data in your form.
Then do not forget to press the save button, it looks like the image below:
Step # 4
Turning Trigger for the script that we have created.
Trigger function to integrate or connect script that we have created with the spreadsheet.
we will arrange for when the responder to submit data through online forms, automatically execute the script and will send a notice to the owner of the form and also to the responder.
the trick is as follows:
a. In the script editor please select the menu Resources > Current Project's Trigger .. ., Looks like the image below:
b. In view of trigger settings click on the link No. triggers set up. Click here to add one now ,? then do setting the trigger as shown below:
In line 1, column Run select emailConfirmation , Columns Event, select from the spreadsheet and on from submit
while on line 2, column Run select emailNotification , Columns Event, select from the spreadsheet and On from submit
c. Click the link also notification for each line that is located on the right, then? make the settings as shown below:
Do it for each row, click ok and then press the Save button.
Until the stages above you've managed to make the notification email google form in html format, to test your form way is as follows:
Please enable Editor form to you, and then press the View life form, looks like the image below:
Please try the online form you, if successful it every time you finish submitting Data, wait automatically there will be a notification email to your email.
#Demo:
for the demo you can click here
Similarly, an article about how to create an email notification google form in html format , may be useful and good luck.
Google form is one of the tools an alternative to create an online form-based web quickly and easily, this tool apart is able to present an interface that can be operated with ease to make form or online form, turns tool is also equipped with a custom script that can be involved to support the weakness of interfacial google form.
Indeed, if only relying on the design alone is not much that can be done by google form, barangkai only able to make an appearance only as a medium for data input, but with the google script google form able to be set in such a way that we can use as needed dynamically.
one function google script for google google form is to make email notification where the contents of the emails can be set and design as desired.
the email will function when there are users who perform data input or submit the data via the online form google form, whenever responder finished entering data via the form google form , then an email will be sent automatically, either to email responder (the input data) or email for a party that serves the form.
With the notification via automated email, online form google Gorm would be more interactive so that any information submitted new data that could be? identified quickly.
How to Create Email Alert Google Form in HTML format
Speaking of email, there are actually two types of email content can be created, the first in plain text format, and the second in HTML format,the contents of the email in plain text format, it will only show the email message in the form of writings without any decoration at all, purely in the form of writings.
while the contents of the email in HTML format, will is able to display images, text color, text in bold and other formats as well as a web page display of colorful images and various forms of writing.
Through this article we will try to make the notification email to form gogle form in html format, using google script for google form.
for this case, I think you've understood how to create a form in google form, if you happen to do not understand, you can take the time to read the previous article about making guide online form with google form.
The following step-lagkah make the notification email google form in HTML format:
Step # 1:
Sign in to your google account your drive, to create an online form you .
to this case once again you I think is already understand how to create a form google form, as well know what a google spreadsheet form.
for practice, first please create a form, as shown below this:
Form the above will result in the spreadsheet automatically, more or less will look like the image below:
Step # 2:
enable Script editor via your spreadsheet data form
Please enable your spreadsheet data, after an active spreadsheet, click the Tools menu>? Script Editor ..., looks like the image below:
Step # 3
In the script editor that is already open, please you enter the following script:
// script confirmation email to be sent to each responder
emailConfirmation function (e) {
? var name = e.values [1]; // retrieve data from a spread sheet name in column 1
? var email = e.values [2]; // retrieving email data in column 2
? var userMessage = e.values [3]; // retrieving message data in column 3
?
?
? var subject = "Email Confirmation";
?
? var message = createHTMLHeader ();
?
? message + = " Hi" + name + "
";
? message + = "Thank you for contacting us superbly
";
? message + = " Your Message Body
";
? message + = userMessage;
?
? message + = createHTMLFooter ();
?
? MailApp.sendEmail ({to: email,
???????????????????? subject: subject,
??????????? ????????? htmlBody: message,
???????????????????? name: "Message from Structure Code"
??? ????????????????}) ;?
}
// script to create e-mail notifications to your email
emailNotifiation function (e) {
? var name = e.values [1]; // retrieve data from the spreadsheet name in column 1
? var email = e.values [2]; // retrieving email data in column 2
? var userMessage = e.values [3]; // retrieving message data in column 3
?
?
? var subject = "New message for you";
?
? var message = createHTMLHeader () ;?
?
? message + = " Hello
";
? message + = "You've got a new message from:" + name + "
";
? message + = " Message Body:
";
? message + = userMessage;
?
? message + = createHTMLFooter ();
?
? MailApp.sendEmail ({
??? to: " exmple@gmail.com ",
??? subject: subject,
??? htmlBody : message,
??? name: "Structure Code"
?});
}
createHTMLHeader function () {
? var html = "";
? html + = "";
? html + = "";
? html + = "";
? html + = "";
? html + = "" ;?
? return html;
}
createHTMLFooter function () {
? var html = "";
? html + = "";
? return html;
}
Please replace the text in red example@gmail.com with your email that you will use to receive notifications whenever there are doing submit the data in your form.
Then do not forget to press the save button, it looks like the image below:
Step # 4
Turning Trigger for the script that we have created.
Trigger function to integrate or connect script that we have created with the spreadsheet.
we will arrange for when the responder to submit data through online forms, automatically execute the script and will send a notice to the owner of the form and also to the responder.
the trick is as follows:
a. In the script editor please select the menu Resources > Current Project's Trigger .. ., Looks like the image below:
b. In view of trigger settings click on the link No. triggers set up. Click here to add one now ,? then do setting the trigger as shown below:
In line 1, column Run select emailConfirmation , Columns Event, select from the spreadsheet and on from submit
while on line 2, column Run select emailNotification , Columns Event, select from the spreadsheet and On from submit
c. Click the link also notification for each line that is located on the right, then? make the settings as shown below:
Do it for each row, click ok and then press the Save button.
Until the stages above you've managed to make the notification email google form in html format, to test your form way is as follows:
Please enable Editor form to you, and then press the View life form, looks like the image below:
Please try the online form you, if successful it every time you finish submitting Data, wait automatically there will be a notification email to your email.
#Demo:
for the demo you can click here
Similarly, an article about how to create an email notification google form in html format , may be useful and good luck.
0 Komentar