This script is going to be used to make surveys to final customers live, I mean there will be people with an ipad asking questions to potential customers, and registering everything in the script.
The survey includes personal information (name, address, email, phone, etc), and also some questions that will change according to answers given in previous questions, for example one question is: Do you use our service (yes) (no), if they say (yes), then the next question is: Which package do you have: (regular) (professional) (elite) … these packages must be accessed from a database, because they can change. And there will be like another 3 or 4 dynamic questions (changing according to previous answers), but with no need to access database for answers. In total there are like 20 questions.
From all the questions (including personal information) only about 2 fields would be required.
At the end of the survey, it will ask: Is this a sale?
If they select yes, then more questions will appear, asking for more details...(required fields)
When they hit submit, the script will need to:
1) Save the information in a database
2) Save the user who filled the survey (there will be like 5 users using the script)
3) Save date and time the survey was filled
4) Generate a survey id number, if it was only a single survey without the sale.. the id would be 001E, but if it was a sale it would be something like 001V (separate counters)
The admin user must be able to:
Login to the admin area
change its own password
create new surveys (by choosing survey name) (it will always be the same survey, the name will change only) - each survey will be treated independantly
close surveys for users - so users can't fill more data to them
fill surveys (even if they are already closed).
Access Log section - this section shows a list of every survey filled.. showing Survey Name, User, Date, Time
Access Report Section - In this section admin can choose a survey, and see all questions and its statistics (a pie chart is needed for each question), this must be live.
Downloadable database in excel file. The admin user, must be able to select survey and click a button: Download Database for this Survey, so he get's an excel file where every question is a column and its filled with all the data from the surveys.
Login / logout
Select a survey (closed surveys must not be displayed)
Fill a survey
Edit a survey (by selecting its id)
The script must be fully functional and without bugs before delivering final payment
Requirements may vary slightly during the development process (I'll be in contact every day)
If major modifications are needed after the script was done, they will be paid as extra.
Please send your best bet, budget is thight on this one.