Hi, i am creating a website for a sports club. To show the various teams if have set-up dynamic pages, works fine. Now, I want to list all the players for each team - of course in a dynamic way via the CMS. So, I would somehow need to be able to add a list of people with height, weight, position etc. and show them on the related dynamic page. I have about 20 teams, each team has up to 15 players. Can I display a .csv file? Do I need to create a new data collection for each team? any ideas? How would I link them up? thank you, a.
I’ve used a repeater for this before. If you get the layout how you want within one section on all breakpoints, then duplicate that section or page for the other teams. Then connect it to the right dataset.
You could even use the opening hours composition template as a basis.
Hi Lewis, thank you very much for your answer - greatly appreciated! But, is the page your example table is on a dynamic page or a static page? For example I have Team A, Team B, Team C etc. all based on the same single dynamically created page. So, to display the corresponding lists for “Players Team A”, “Players Team B” etc. on the correct page I would somehow need to make that connection dynamic as well, or am I missing something? Otherwise, I would always have the same data on the page? Thank you, A.
I am creating a poker league leader board. We have several managers who run the game at different locations. We have stats for all kinds of things, but it in order for it to work, I have have to create my own table that includes multiple data sets connected to three different databases in order to keep the leaderboard up-to-date. Not done yet, but my trial run worked out pretty well.
Your games between 2 teams are like our games at a particular venue between 20-30 players at a time. There has to be player position table for that night which I associate with a venue data set with focus on rank, points, and bounties for that night.
Then the overall “standings” I associate with a player data set with focus on over all rank, total points and total number of bounties collected. The list will include their last three positions at a particular venue, who ranked above them and below.
To this I had create a Players, Venues, and League Database, each with multi-reference fields so that they could talk to each other.
Still need to figure out functions, but I think I might let an excel spreed sheet add those and then re-import that data from time to time.
All still in progress. I hope to have it finished soon, but again, it is all working pretty good in my tests so far.
In your case you will need a
Players Database (like our players)
Teams database
Games database (like our venues)
League database (like our league)
There are many already built out apps and services you could use and embed them into your site, but I really want to push Wix past some of the cruddy ones we’ve used in the past.
Teejay
hi teejay, thanks for your input! I think I get the cross references between the CMS collections / Datasets, totally makes sense. But would it also work on dynamically created pages? In your case, are the pages you are building all these tables on dynamic or static? Static would work of course but I am not sure how to makes the tables know which content to display when all the Team Pages are created dynamically. How is it working in your case? thanks a lot! best, a.
I build the collection points on static pages with the multiple data set connections on each page. The cross-references occurs in the spreadsheet of the content manager. I tend to design my own repeaters from scratch and not use a spread-sheet-like repeater. Gives me more control. If you want to access this page, sign-up and I can let you in https://www.rivercitypokerclub.com/leaderboard
Out to lunch in the next hour.
ok thank you! i was hoping for a solution with dynamic pages like in elementor/Jet-engine, but not there yet apparently. i probably make static sites with a small amount of design assets or something…thanks anyway
From that list I shared, one will be able to click on the player name which will the stats and other notable characteristics of our player, very similar. Again this is still under development.