Hello, I’m building a fantasy sports game and I’d hoping to allow for multiple contests to run based on the same game (as each game will have different prizes).
I have been able to build this but I am having trouble allowing multiple unique submissions for each entry.
The challenge is if the participant is in 2 unique contests that are using the same data source (i.e. the same game)… when they input their entry, it is matched against both contests. I would like to allow independant entries.
I understand I could create 2 columns in the user profile sheet, but I would like to make this very scalable and that is not my preferred solution. I’m hoping there is a way to create a relationship which can filter related items to present the right entrant in the right contest, unique to other entries using the same base source.