Jump to content


  • Posts

  • Joined

  • Last visited

MeralomaFC's Achievements

  1. What a phenomenal response, thank you so much for taking the time to provide all that detail. I'll let you know how I get on. EDIT: Can't use Triggers on a free account, and since my project is only going to last 3-4 weeks, I can't justify getting a paid account (and the free account won't be active for long enough). Thanks for your help, though.
  2. Hey everyone, 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) First_Name Last_Name 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.
  • Create New...