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.


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, spreadsheet in javascript, script google spreadsheet, not valid email address, not a valid email address, mail merge google, html spreadsheet code, html form to spreadsheet, google spreadsheet html, google mail merge, google html email, email is not valid, email address not valid, email address is not valid, codes in javascript, email g, anonymous e mail, first name email, email spreadsheet, automate email, mail merge 1000 email, create google spreadsheet, javascript spreadsheet, copy email address, 1000 google email

Tietoa työnantajasta:
( 24 arvostelua ) Toronto, Canada

Projektin tunnus: #1720394

2 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


Please check PMB

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

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

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