a new website that I want to create is about different football teams in different cities. Every time after a football match, the scoring points shall be entered into the relevant table for the relevant city, so the table always shows the latest results of the games.
Currently, the "ugly" dummy page is this: https://www.urbansportsleague.de/berlin-1st
Take a look at the first table "summer league 2019". After every football match, the values in the columns "games", "won", "lost", "points" will change. Depending on the "points" value, the table must be newly sorted (automatically!) every time after a match (=column "rank").
>> I assume this can be done with a database and a page showing a dataset that is automatically sorted by the field "rank"? Is this possible?
There will be several contributors to the site entering data ("points") into the database. Every city has a different contributor to the WIX page. Ideally, this won't be a "contributor" though, but a "site member" who logs in on the live website and amends existing data in a database. This way I want to make sure that several "site members" can change the "points" of their team.
>> Is this possible?
Can you please let me know if I'm thinking this through correctly here?