Jan 11, 2023 03:10 PM
How can I get the Submissions Field to only show data that is related to the user AND challenge of the current record? Right now it's showing all of that user's submissions for any challenge, instead of just the submissions that go with the challenge in each record.
Jan 11, 2023 03:32 PM
Hey Holly. Which linked field is that Submissions field tied to?
Jan 11, 2023 04:18 PM
It's coming from the User table which is linked to the Submission table. Makes my head spin trying to keep it all straight!
Here's a link to the base, just test data in there right now.
Jan 18, 2023 06:01 PM - edited Jan 18, 2023 06:02 PM
Did you get this figured out? I looked at your base and it looks like your summary table is duplicating your Submissions table, rather than summarizing it. What, specifically, are you trying to summarize? The submissions by User by Challenge?
I think you probably need a junction table of User & Challenge, which you kind of already have.