Hi!
I’m building a website for users to apply for rental apartments. If more than one user applies for the same apartment they are sorted by which date/time they applied. BUT, each user can also “boost” themselves to climb up in the queue. So a user that applied after everyone else and is the last one in the queue could “boost” to get to the first place.
Now my problem, I want to show each user which place in the queue they currently have. I can do a search for the data type containing all users that applied and sort it by “boost” to get a list of all users and their place in the queue. But I would like to go through this list until I find the current user and count each user that is in front in the queue.
So for example: user1 has a “boost” value that gives him third place in the queue. How can I show this information to the user? For apartment X your place in the queue is 3?