Send user information from another sheet

Hello Guyz,

I am pretty sure my problem i snot a big deal but for me … :sweat_smile:

User 1 make a bet on Race 1 and a bet on Race 2 in race Tab (google sheet)
I just want to get thoses bet in my member Tab for the User 1 and not for all :frowning:

(Here is my app : Glide)

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.