# Who goes up and who goes down in my padel ranking? **URL:** \ **Category:** Ask for Help\ **Tags:** actions\ **Created:** [January 31, 2021, 4:44pm UTC](https://community.glideapps.com/t/who-goes-up-and-who-goes-down-in-my-padel-ranking/22031 "2021-01-31T16:44:08Z")\ **Posts on this page:** 8\ **Page:** 1
**Author:** ![Nicola\_Albini](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nicola_albini/32/20840_2.png) [@Nicola\_Albini](https://community.glideapps.com/u/Nicola_Albini)\ **Post date:** [January 31, 2021, 4:44pm UTC](https://community.glideapps.com/t/who-goes-up-and-who-goes-down-in-my-padel-ranking/22031/1 "2021-01-31T16:44:08Z")
Hi everybody, I’m a real glideapp rookie. I made an app to manage padel matches for a group of 16 people. The core of the application is the ranking. The ranking updates automatically every time the result of a new game is entered. I would like that every time I click on “enter result” the ranking would be saved in a different column. So I can compare the “new ranking” with the previous one and understand who goes up and who goes down (and add icons). Any suggestion? Thanks a lot ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [January 31, 2021, 5:45pm UTC](https://community.glideapps.com/t/who-goes-up-and-who-goes-down-in-my-padel-ranking/22031/2 "2021-01-31T17:45:48Z")
Hey Nicola welcome to the community! I would consider taking a different approach to the structure of your data. Instead of using a new column for every result you could take advantage of the _Special Value Current date/time_ component and use the resulting dates and time for the logic. Have a look at the [Glide Library](https://docs.glideapps.com/all/). There is loads of great information and tutorials in here. And if you have any questions there are lots of friendly people on here eager to help. ---
**Author:** ![Nicola\_Albini](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nicola_albini/32/20840_2.png) [@Nicola\_Albini](https://community.glideapps.com/u/Nicola_Albini)\ **Post date:** [January 31, 2021, 7:07pm UTC](https://community.glideapps.com/t/who-goes-up-and-who-goes-down-in-my-padel-ranking/22031/3 "2021-01-31T19:07:15Z")
Thanks for the reply Eric. Match results are recorded per row in one sheet. In another sheet there are the calculations for the ranking. It is a ranking based on RPI (rating percentage index) (25% team winning percentage, 50% opponents’ average winning percentage, and 25% opponents’ opponents’ average winning percentage) so every new game result modifies the entire RPI column not only the points of the teams involved. This is why I would like to “copy” the data of the RPI column (in other column) before the result of a new game is inserted. ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [January 31, 2021, 7:32pm UTC](https://community.glideapps.com/t/who-goes-up-and-who-goes-down-in-my-padel-ranking/22031/4 "2021-01-31T19:32:36Z")
In that case you could use an “add row” action. If you are using a form to submit the data just head over to the features section in the top right and you could choose add row 👍 ---
**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\ **Post date:** [January 31, 2021, 7:33pm UTC](https://community.glideapps.com/t/who-goes-up-and-who-goes-down-in-my-padel-ranking/22031/5 "2021-01-31T19:33:31Z")
What if you had a single value column to get the last entry and another single value to get the 2nd last entry? Then you’d be comparing the last values with the 2nd last values (and each time a new one is added, the previous “last entry” becomes the 2nd last, etc etc. ---
**Author:** ![Nicola\_Albini](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nicola_albini/32/20840_2.png) [@Nicola\_Albini](https://community.glideapps.com/u/Nicola_Albini)\ **Post date:** [January 31, 2021, 7:51pm UTC](https://community.glideapps.com/t/who-goes-up-and-who-goes-down-in-my-padel-ranking/22031/6 "2021-01-31T19:51:13Z")
Thank you both. I’ll study “add row” and try to use it ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [February 1, 2021, 12:06am UTC](https://community.glideapps.com/t/who-goes-up-and-who-goes-down-in-my-padel-ranking/22031/7 "2021-02-01T00:06:57Z")
This is a great approach and I believe it will work. ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:53pm UTC](https://community.glideapps.com/t/who-goes-up-and-who-goes-down-in-my-padel-ranking/22031/8 "2024-01-17T16:53:42Z")