Suljettu

Email subscription page with automatic response

Services required: Google Mail, Google Form, Google Spreadsheet

Create custom script on Google spreadsheet that links to a form and automate an email response back to the email address merge-tagged with a unique value.

userflow:

1. Administrator copy and pastes 8 digit voucher codes in Column E from another source (e.g. all the way to row 1000)

2. Anonymous fills out a form with First Name, Last name, Email address and click submit.

3. Email addresses gets inputted onto the spreadsheet by the system; script validates the email address and sends an html response along with a value in column E (one voucher code) to that email address.

*if email address is not valid, don't send the email.

*one email submitted gets one unique voucher code only, no voucher code should be sent to two different addresses.

*only one submission is allowed from the same email address

Taidot: HTML, Javascript, MySQL, PHP, Komentosarjan asennus

Näytä lisää: spreadsheet javascript, script google spreadsheet, valid email address, mail merge google, html spreadsheet code, google spreadsheet html, google mail merge, google html email, email valid, email address valid, email g, anonymous mail, first name email, email spreadsheet, automate email, mail merge 1000 email, create google spreadsheet, javascript spreadsheet, copy email address, 1000 google email, javascript form copy, send form email address, merge javascript, merge mail, send page email

About the Employer:
( 24 reviews ) Toronto, Canada

Projektin tunnus: #1720394

2 freelanceria on tarjonnut keskimäärin 850 $ tähän työhön

casper123

Please check PMB

200 $ CAD 4 päivässä
(40 arvostelua)
5.8
WUS6s2aF5

Custom software development - <b><i>Removed by Admin</i></b>

1500 $ CAD 1 päivässä
(0 arvostelua)
0.0