- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jan 11, 2023 03:32 PM
Hey Holly. Which linked field is that Submissions field tied to?
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
https://airtable.com/shry0UkPpDs0czsjZ

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎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.
