The context :
I have a page called “event” in which I enter race results. (Position, point…etc)
The results are updated via a WORKFLOW API in an “event results” database and which updates the total points of each user in a “general ranking which contains the total points” database
So far so good, it works perfectly.
On another page called “general ranking” we find all the users filtered by the number of total points in a reapeting group.
Which brings us to position P1 for the one with the most points. The P1 position is simply the display of the current cell index.
My question :
Currently, when each event is finished, I have to update each entry via a repeated button on the general ranking page so that the current cell index becomes the “current position” and at the same time I take advantage of updating the "position before update” to display a small icon of + or – evolution compared to the previous result.
Is there another way for this position to be done automatically or via a single button? The make change on the list does not work because I do not have access to the input in the reapetin group
There are many ways of doing what you want and the answer (and the way to make it efficient) depends on what your data structure is and what your requirements are.
Have you thought about how to store the data depending on what you need to do with it later on?
The first organisation method I can think of that can be “future proof” is
Thing Event :
Ranking : list of Event_Participants_Log
*Event name : text
Thing Event_Participants_Log :
player : type “Player”
points : number
Thing Player :
name : text
Each participant do his stuff in the event. At the end of the event, you click a button that triggers a workflow and :
Make changes to a thing “Event” → set “Ranking” = Do a search for Event_Participants_Log sorted by points : decreasing YES.
That’s it. You have your points and ranking in the “Ranking” of the Event.
I don’t know if I understood correctly but maybe I’ll elaborate a little more:
I have 2 types of data that are impacted:
General classification :
User
List of result event (referring to the table below)
Total points: (Total points for all events)
*Current position :
**Position before update:
Event :
Évent name XXXX
Point win: (ex 20 point)
Event position: (ex 2)
I have no problem automatically updating all data fields except for the *** fields which I update one by one via a button in each repeated row.
However, I would like this “*Current position” which is ultimately that the order of the users from the largest number of points to the smallest is updated at once via a button or something else to which I do not I wouldn’t have thought.
