Project Help - design a ticket distribution system

Like (0) Share

Report

Posted on 21 Feb 2023 16:44:20 by KYDerick92

I need assistance with using microsoft sharepoint. I believe it has the tools i need, but am struggling to put it all together.

I am trying to create a ticket sign up form using microsoft sharepoint for baseball season tickets. The tickets are for numerous dates (70+) and have a limited amount of tickets per game (4).

Ideally, a participant would complete a form (including their name and email) and select 1 of the 70+ available dates. The submission would then be captured on a list that i can easily review/download.

A couple restrictions (if possible)

-if the date has already been selected (all 4 tickets are gone), then it would be removed from the available options on the form

-every ticket that is claimed should reduce the amount shown as available on the form (if 1 ticket has been claimed... the amount available would be updated from 4 to 3)

Any guidance on how to make this would be greatly appreciated!

-Derick