I need the ability to send form results to an excel (.xml) spreadsheet then email the user that particular spreadsheet with all the new data in it. However before the email attachment goes out to the user, they are going to be directed to PayPal where they will buy the excel file. I already have the excel file and HTML form built. The excel spreadsheet i built already has all the calculation formulas in there that a person needs. I need you to build me the code that will do all of this for me.
Here is how it should all work in the end...You are responsible for making the following come true.
***Remember i am giving you both the excel file and the HTML form****
When the internet user completes the form online, he/she will be brought to my PayPal page where he/she can buy the spreadsheet. After payment is complete, the user will receive an email with the attached spreadsheet. Inside the spreadsheet will be all of the date that user entered into the form. The excel document will arrive as a "locked" workbook, this way users cannot modify the rows and column for continual future use. Also the formulas in the Excel file need to be hidden so that users cannot see how the data is calculated. The locked spreadsheet will contain all of the data the user entered from the online form plus some empty unlocked cells where the user can enter their score later on that day.
You are responsible for the following:
Sending the user to my PayPal page to buy the form first.
Setting it up so that the user can purchase spreadsheet on PayPal or via credit card.
Taking my form and making the form results go to particular cells in Excel.
Sending the excel file as an email attachment to the user.
Excel file that is send will need to have certain cells "locked" and other cells "unlocked". The calculation formulas will need to be hidden from the user.
***For this project to be completed, it will need to work just as i described in the second paragraph above on my server. Also you are responsible for loading the information on my server and making sure it works as described above. I will send you my server login information so that you can load and test.
Here is an example of how the form fields will go into excel...
HTML Form Fields --> EXCEL File
First Name --> Cell A2
Last Name --> Cell B2
Email --> Cell A3
Phone --> Cell C1
***Don't worry I will let you know what cells the form fields are going to. (e.g First_Name --> Cell A2)***
Also the individual cells (A2, B2, A3, C1) in the EXCEL Attachment needs to be "locked" when it is sent so that the user cannot modify the data.
****Here is some information about my current server***
Operating System: Windows
.Net Runtime Version: ASP.Net 2.0/3.0/3.5
PHP Version: PHP 5.x
IIS Version: IIS 7.0
SQL Server Databases: 1 Available
MySQL Databases: 1 Setup of 10 Available
Shared Hosting Server with Godaddy.
****See Attached PowerPoint file for additional details*****
28 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön
I have an experience in all what it takes for this project (PHP, PayPal integration, Excel template editing, email sending). So I can easily do this job for you. If your interested in my bid we can discuss the details.
We have done similar work for our previous client. We have a ready to use solution for this requirement. Give us a chance to showcase our expertise Thanks, BSB's