Auto Calculate Player Ranking

Hi there

I brand new to AppSheet and really enjoying it thus far. Have taken on a application challenge but am currently stuck. The application is designed to keep player information (Name, contact details ,etc) and especially the players current ranking (1-x)โ€ฆ I have 3 tables namely Members, Competition and Competition_Entry for now. When a competition is created the players has the option to opt in or out of the competition that will update the Competition_Entry. There will be rules later on to determine who plays against who. When the player wins a higher rank player the winning player automatically gets ranked in the higher players ranking spot and the losing player moves one spot down following the rest of the players ranked lower(current ranking +1). I want to know if there is a way how one could do that automatically when the ranking is changed manually in edit modeโ€ฆ This will later be automated in the background if the players enter there results.

Hope this is enough informationโ€ฆ

0 2 173
2 REPLIES 2
Top Labels in this Space