I'm running a raffle for my soccer team, and I need to keep track of ticket sales.
My data table is very simple:
Ticket_No (prefixed autonumber)
Player_Name (drop down)
I would like the players to be able to input their ticket sales into the database using a web form.
I would like for them to have the option to input 'number of tickets' and then when they hit submit, it would add a new row into the database for the number entered into that field. So if they enter '3' it would enter 3 rows into the database, each with the same First Name, Last Name & Player Name, but each with a unique Ticket No. I would then like to be able to have the post-submission pop-up to display the ticket numbers. e.g. "The ticket number for [@field:First_Name] [@field:Last_Name] is: [@field:Ticket_No]." (Even if it has to repeat that line each time for each entry, that would be fine.
I figured this would be a pretty simple thing to create, but I'm having a lot of issues trying to find any solution, so I'm hoping someone here will be able to help!
I thought about switching strategies and using list enter/edit, but I was worried about people accidentally inputting over the top of each other, plus I'm assuming it isn't live, so if multiple people enter at the same time, it wouldn't work.