Initial scope for this project is very simple, but has the potential to grow into more work after the first testing phase.
Need to build a simple web based application with a backend database that contains seed data including user ID numbers (for validation that only one submission is made per ID) along with a list of strings which will populate 12 unique drop down menus to create a list which the user can then submit, after solving a captcha.
Submitted data will need to be stored in database so the administrator can view both individual submissions by user ID, as well as have a view of the aggregate number of times each string is chosen on all forms.
What I am seeking to have built is a web application where people can be sent a link to a site (I'll provide the hosting - LAMP stack) and they will be choosing from a list of 26 venues
(I'll provide the names via CSV) to form a schedule of 12 venues which gets submitted to the database so I can review after a certain duration to tally the final votes.
i would like this to be something re-usable, but still retain historical data, so the ability to create a new "vote period" is desired.
i would like to upload a new CSV every 3 months or so containing new venues to seed the drop down choices, as well as seed the list of user ID's that are allowed to submit a vote
There are 26 venues, and each user can choose 12. I would like the ability to toggle whether or not duplicates are allowed for a particular voting period.
so the purpose is really just to tabulate voting -- we previously did this manually and it became a nightmare to manage because we didn't have standardization of the way the track names were spelled or some people used abbreviations.
If they come from the database, and users pick from a drop-down, then we are sure to get accurate results that don't need manual correction
i would also provide a CSV of the user id values -- i want the user prompted to enter their user ID (they will know what it is) first, then pick 12 venues from the list of 26 and once they have filled in all 12 boxes, then they can submit.
Bonus points if once their user ID has submitted, they cannot submit again, but I can always add this on my own later when I have the time to devote to it.
Extra bonus if I can toggle a "vote period" to allow duplicates or not