I am trying to implement something like a badge system, where users have points that can go up or down and there are badges that have a minimum of point required to acquire. A person applies for a badge rather than getting it automatically (but I’m not concerned about this part).
Lets imagine the scenario
Badges name | points required
Badge 1 | 250
Badge 2 | 400
Badge 3 | 550
Then I have users
user name | points required
user 1 | 280
user 2 | 410
user 3 | 600
What I want is to display a list in their user profile that only includes the badges they are eligible to get.
User 1 could only get badge 1. User 2 would be eligible for badge 1 and badge 2. User 3 would be eligible for all badges.
I’ve tried with formulas but I am certain I am doing something wrong. It would be relatively simple if I could use dynamic values on the filter as I could discard anything less than.
Any ideas of how I could solve this?