# How to show all previous challenges unlocked by the signed-in user?

**URL:** <https://community.glideapps.com/t/how-to-show-all-previous-challenges-unlocked-by-the-signed-in-user/83601>\
**Category:** Ask for Help\
**Created:** [August 1, 2025, 8:14am UTC](https://community.glideapps.com/t/how-to-show-all-previous-challenges-unlocked-by-the-signed-in-user/83601 "2025-08-01T08:14:30Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![timmckern7](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/timmckern7/32/86907_2.png) [@timmckern7](https://community.glideapps.com/u/timmckern7)\
**Post date:** [August 1, 2025, 8:14am UTC](https://community.glideapps.com/t/how-to-show-all-previous-challenges-unlocked-by-the-signed-in-user/83601/1 "2025-08-01T08:14:31Z")

</div>

Hey guys! I’m only new to Glide in the last couple weeks, but loving it so far.

I’m building a mindset challenge app and trying to figure out how to display **all previous challenges that a user has unlocked** , based on what day they’re up to.

Here’s what I’ve got:

- A **Users table** with columns that calculate what day each person is currently on (e.g. Wal is on Day 3)

- A **Challenges table** with a `Day` column from 1 to 28

- The **layout source for “All Challenges” is the Challenges table**

What I want is:  
If Wal is on Day 3, the “All Challenges” screen should only show Challenges 1, 2 and 3. It should hide anything beyond the current day.

I imagine I need some sort of relation or lookup that pulls the user profile into the Challenges table or compares the day somehow, but I’m not sure how to make that happen or how to reference the currently signed-in user.

I already have a separate tab that correctly shows **today’s challenge** , I just can’t figure out how to show **all previous ones together**.

Hope that makes sense! Appreciate any help 🙏

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/1/c17c66de9b52aaa5576abfb4519678fa2ff4bc27.jpeg)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/1/c15cf84b282b466bffc628035993afef084a73e9.jpeg)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/e/bed2eda605d3f024c367b3b0a4d0fe831f3d7604.jpeg)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/4/c479fd18896b27c53d140e71c4febccd079a6811.jpeg)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [August 1, 2025, 8:19am UTC](https://community.glideapps.com/t/how-to-show-all-previous-challenges-unlocked-by-the-signed-in-user/83601/2 "2025-08-01T08:19:34Z")

</div>

Use a filter on your Collection: “Day is equal to or less than User Profile→Days Since Challenge Started”

---

<div class="post-metadata">

**Author:** ![timmckern7](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/timmckern7/32/86907_2.png) [@timmckern7](https://community.glideapps.com/u/timmckern7)\
**Post date:** [August 1, 2025, 8:28am UTC](https://community.glideapps.com/t/how-to-show-all-previous-challenges-unlocked-by-the-signed-in-user/83601/3 "2025-08-01T08:28:26Z")

</div>

Wow I’ve spent 3 hours trying to work that out and you fixed it in 2 seconds! Thank you

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [August 8, 2025, 8:29am UTC](https://community.glideapps.com/t/how-to-show-all-previous-challenges-unlocked-by-the-signed-in-user/83601/4 "2025-08-08T08:29:05Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.