Formula Question

Hi all, I have a simple database for tracking golf scores, and on my leaderboard page I want to display the number of times a particular player has beaten the other. In my database I have each players total score…so really all I need is a < function but I’m having trouble doing it.

Attached is a pic of my database structure. Very simple, the rounds are posted on the date they are played and each player has a total score. Now on the leaderboard I want to see a total count of the number of times player 1 (kyle) has won. Aka Kyle’s score < Peter’s Score.

Also here is my almost complete formula that is broken. I think it has to do with the way I’m calling / counting Peter’s score. If you know the option I should be selecting instead please help. :slight_smile:

Hi there, @kyle4… if I understand your post correctly, you would need to use an advanced filter because of the way your data type is set up. The advanced filter would look like this (if you have never used an advanced filter before, the Advanced option is at the bottom of the dropdown when you add a constraint to the filter).

As you may or may not know, advanced filters happen on the client (browser) side. So, the search is going to return every item in the data type to the browser and then the filter will be applied. If you don’t want that to happen (I’m guessing it won’t really affect performance because there probably won’t be hundreds of items, but you never know), a simple change you could make is to add a field to the data type that stores the winner of each round. At that point, you would be able to do a search with a simple constraint to get what you need.

Hope this helps.


Edit: too damn funny, but I knew I remembered chiming in on something similar to this post at some point in the past. Has it really been 2 years?!? I guess time flies when you’re Bubblin’.

1 Like

haha yes 2 years indeed! Thank you @mikeloc for the help. I will try to deploy this method. The app has been in use by a buddy and I for the past two seasons and it’s starting to gain some interest so I may make it a public release this coming spring.

1 Like