Send user information from another sheet

I would probably create a form button on the race details page and write the responses to a new race bets sheet. You can pass in the race name along with the form submission using Column values and the user’s email using the Email special value. All they should need to select is their color choice. Then you can create a relation column on the members sheet to link the email address to the email in the form response sheet. That will give you all race selections for that user.