Ticket collection /checking system using googledocs spreadsheets


#1

I need a ticket redemption database.



I have created a simple database in googledocs. Basically what i want is this



A form to input data, not just any but a slightly interactive form.



Input Form

============

I want to be able to input Name (Textbox) Surname, (Textbox), Type of ticket (From Dropdown menu), Contact Detail( textbox), Table Number (should be limited from 1 - 30), Seats ( one to 12 - this can actual check in real time how many seats available and only display a drop down with 1 2 3 4 upto maximum seats available. Once all twelve seats are taken then it shouldnt allow input of seats on that table.)

Retrieval Form

============

On the wedding day ppl come and say their name / surname

The form should do a lookup and find that name and display in a nice window. Have Table Number displayed big letters as it is whats important but also have all details of customer displayed too. Once guest has been given there should be a tickbox to say this person has come in. If one person buys multiple tickets there should option for them to come in and only have say 2 tickets marked as used and the remaining three remain valid. Incase their husband is still looking for parking or something.



can u do this? Let me know if you can.