Hello,
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?
Kind regards,
Helene
Hi! I saw your website and it’s very awesome. I’m in a football association in Milan and we also have a League with a urban football championship.
I would like to put on our website the same features of you website (schedule, table, etc.)
Can you maybe explain me how to do ? Or maybe can you pass me in any way the product?
Thanks a lot and congratulations for the site
Hello,
my initial post in this forum was about a project that did not happen unfortunately. So I cannot give you any feedback on this matter as I don’t know the answer myself. Very sorry.
Ah ok! So, didn’t you create the site as it appears now?
no, I didn’t. I have nothing to do with the current website.
You can sort your datasets through their own settings itself.
https://support.wix.com/en/article/sorting-database-content-displayed-on-your-page
Or you can do it through code with setFilter.
https://www.wix.com/corvid/reference/wix-dataset.Dataset.html#setFilter
You can even have a default order for your table, say points like a normal league table and then you can have additional options where you let the user sort the table by wins, draws, losses, goals for, goals against, etc, etc.
As for allowing others to contribute to your site, if you want them to have access to edit datasets etc then they need to be site contributors.
https://support.wix.com/en/article/about-roles-permissions-contributors
https://support.wix.com/en/managing-your-site/contributor-roles-permissions
if you are just wanting certain site members to input data into a new dataset, then you can look at giving those site members certain roles within your website, then you can give those members only with a manager role for example, access to the user input form page where they can add that weeks results or team etc.
https://support.wix.com/en/article/creating-member-roles-6943237
https://support.wix.com/en/article/managing-your-member-roles
https://support.wix.com/en/article/changing-the-permissions-of-a-member-role