Hia,
I’m building a site for a festival with multiple venues and multiple lineups. I’ve created a dynamic page that pulls data from my “Venues” collection and have referenced a “Lineup” to each venue.
I want to use a repeater to display my lineups as some venues have 5 acts and some have 15+. Currently I can’t think of a way to do this with how the data has been entered on my spreadsheets as I’m having to manually link to “Time1, Act1, Time2, Act2” etc.
I have to reference each column from my lineup database rather than it generating a repeated grid of lineups relative to the amount of acts I have.
Ideally I’d like to import all content into my site from 2 csv files, one with the venue info and one with the lineup info.
Do I need to make a collection for each lineup instead?
Or do I manually link up all the Times + Names (up to the maximum number of acts on a lineup (15)) and then set a filter to only display if there is content in the column on the database? Would this only hide the text rather than hiding the background under it?
Struggling to get my head around this so apologies if any of this is unclear!
Thanks so much for your help. I had it working in theory before but due to the formats of the Lineups I’m struggling to workout how to link it up.
To give a bit more detail, each venue has 1 lineup. A “lineup” is a list of 5-20 Names that each has a start time.
I tried to put all lineups on one collection and then reference the venue. But in my dynamic page I had to individually connect up the names/times e.g. Artist 1 Name, Artist 2 Time…Artist 19 Name… and so on. Because of this it wasn’t dynamically displaying the amount of acts in each venue and the venues with less acts had a load of “heading” sample text.
So instead I have seperated each lineup into it’s own collection so that the repeater pulls the exact amount of acts. See example below where “Broadway” is the name of venue.
The issue with this however is that I can’t figure out how to dynamically connect this to all the pages. I also can’t manually add a different venues lineup onto each page as they are dynamic pages so every change I make to 1 page is made to all of them.
How can I reference an “Act Name” and “Act Time” if these fields only exist within the specific collections of the lineup and not the overall venue dataset that the rest of the page is using?
Alternatively if there is a way to display content outside of my main venues collection on these dynamic pages and reference a unique lineup collection per page that would solve the issue too.
The heading tag sounds strange as it should only load fields that match the filters to the dataset.
I think you may be complicating it by having separating all of the lineups and the venues. It might be simpler to have less datasets then let have the pages pull up the information based on the filtered page or you can just have all the information listed.
Thanks for a quick response! I agree I was definitely over-complicating things.
I actually ended up just using a normal text field for in my venues collection. There were some Lineups that didn’t all adhere to the Time:Name format as well so it has resolved that issue too.
I think the issue I was having is that the lineups are thought of more as groups rather than individual artists because there are so many (400+) so inputting them each individually into one big collection would be quite time consuming but I will definitely take that approach next year.
I quite like the site and glad it was working. It might not save time since it stills needs to be inputted but you can import a CSV if you find that easier or if have it already in a .csv format.
