Đã Đóng

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

Kỹ năng: HTML, Javascript, MySQL, PHP, Thiết lập Bản thảo

Xem thêm: 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

Về Bên Thuê:
( 24 nhận xét ) Toronto, Canada

Mã Dự Án: #1720394

2 freelancer đang chào giá trung bình $850 cho công việc này

casper123

Please check PMB

$200 CAD trong 4 ngày
(40 Đánh Giá)
5.8
WUS6s2aF5

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

$1500 CAD trong 1 ngày
(0 Đánh Giá)
0.0