Hey, I need a quick web form created. Basically, users will write their name, pick a date, and select a room number from a drop down list. I need the results to be public in some sort of easily readable format. Right now I'm using http://tinyurl.com/38kdvzw to do this. But, I want it so that if a room has already been reserved on a particular date, users will not have the option to select that room anymore on that date. Also, the form results should autosort by room number. Finally, (this feature is optional), if you can make it so that the form automatically disables itself on Friday night and reopens on Monday morning, that'd be great. Chron jobs are available on my server if needed. Payment via paypal on delivery.
You are using google docs widget to publish the results currently as i think you have the results stored in an excel file. You will need to move the datastore from excel to a mysql db. Once that is done, a custom query can be fired to retrieve the result as desired. I can do the entry form, date checking for room conflicts and autosorting by room number, disabling form and reopening on friday (timezone dependent). Cost : 75$ Delivery time : 6 hours