Comparing data from same table but different user

Ask for Help
1

I have a golf score recoding app that records scores per hole by individual players (HoleScores table).
I want to be able to pull scores per hole from the opponent and compare to determine the winner of the whole.

1 Like
2

Assuming that you have:

  • A table that contains a list of Users (Players)
  • and a reference to each player in your scores table

then you should be able to:

  • create a query/relation from your Players table to your Scores table
  • and then do a rollup through that query/relation
  • and then present your players list on a collection, and sort by the rollup column
2 Likes