We are busy building a Sport Event registration solution for Cyclists to enter for an Event. We will have an Appsheet form that they complete as a Public App on our Website. The Cyclist will supply in the Appsheet form their personal detail and the race/distance that they want to partake in. So basically just “deposit” ther information and the form will reload to a blank form agan. We then use the email they supplied and email them their Race ID We have done the App and must just do the automated email - I think this is possible?
Here are our challenges: 1. We do not want them to complete the Blank form more than once or lets say we do not want duplicates. So if their Personal ID Number is already in the Sheet we want a mechanism to not add it again and just load the Blank Form again. Not sure if this is possible. 2. On Race Day we want them to check-in at our Kiosks (Android Tablets) where they must supply their Race ID that we mailed them by typing it in in an Appsheet form on the Tablets available and then we want to display their Personal Detail with a Check-In Button that they wil have to click on and where we then change their Status to “Checked-In” from the original Status of “Entered”
Is this possible in Appsheet?
We want to do this ourselves and not hire an Appsheet developer because of budget constraints and was hoping for the generosity of this community to assist us. We will share the App when done on this forum for people to use Appreciate any help