A event was organized by Hitachi home appliances team to celebrate 5 years of business between Hitachi and Bing Lee. Attendance was by invitation only and not transferable. Bing Lee employees were requested to RSVP by March 18.
To meet the requirements, I built a RSVP form. The form was built with PHP, MySql, CSS and HTML.
Email addresses of Bing Lee employees were imported into a MySql database table from an Excel sheet. The email addresses were also imported into Campaign Monitor. Email invites were sent from Campaign Monitor to Bing Lee employees with a customized URL which had employees email address appended to it. To prevent uninvited guests from using fake email address in the URL, validation code was added in the form to check if the email address from the URL matched a email address in the database. Since the invitation was not transferable, employees were given one chance to respond. If they tried to access the form after responding, they were shown the message, “You have already responded. Thank you.”
Employee responses were saved in the database table and shared with Hitachi marketing team.
I have setup a demo of the PHP form with test email addresses on my website. Please click the URLs below to see the form.
Below is a link to the form before the user responds.
https://alfredkumar.com/portfolio-demo-files/websites/hitachi/bing-lee-rsvp/?email=alfred1@test1.com
Below is a link to the form after a user responds.
https://alfredkumar.com/portfolio-demo-files/websites/hitachi/bing-lee-rsvp/?email=alfred5@test5.com
Below is a link to form data. The page will show a list of users who responded. This page also has a button to download the data in Excel format.
https://alfredkumar.com/portfolio-demo-files/websites/hitachi/bing-lee-rsvp/export-db/