I’m working on an exercise (running) app that is based off of a monthly point system. When I look at the monthly leaderboard, I get the users entire workout history and it brings in multiple months.
How can I filter the leaderboard to only read workouts that happened in November? Or October, etc?
Thank you!!
You can create a Date Format computed column in the same table:
In the user profile table, create a column for the selected filter:
You can set it as user-specific, but it doesn’t really matter.
Create a table with month names:
In the main data table, add an if then else column to tell if the data must be shown or not:
In the layout editor, add a choice component and set the source to the month names table. Write to the user profile → selected filter that you created earlier:
On the collection, set a filter with a single option:
Voilà!
Wouldn’t you want November 2024, October 2024 instead of just the month?
If you do @Glider10, just add YYYY to the template
Inspiration:
This is still my go to post everytime i have to work with dates filtering 
Gold
Thanks y’all! I love this community. Worked quite well!
