We are transitioning over to a new forum platform. Please post new issues there. Existing threads will be dealt with here unless you choose to move them over. Visit the new forum
Runway collections - filter related select list
I have a project that will start in a couple of months and I'm unsure how to approach one aspect of it.
Collection 1 (players) will have 2000+ individual items, each belonging to a number of categories (seasons played).
Collection2 (games) will have individual items for each game and will have a relationship to Collection 1 - the players will be selected to record who played in each game.
Once Collection 1 has been fully populated, choosing the players per game will mean selecting from a list of 2000+ items... There is one related tag per position in the team for the game.
I've played around with a few different things, but can't find a way to do this - ideally it would be great to somehow introduce a category filter (only bring out the players who have the category that covers the season the game was played in) - but I'm aware how difficult that would be to implement, especially as the season of the game won't be known until the game has been saved. I think I could get round some of that with a custom app, but it would be nice to keep the data in collections.
Am I thinking along the right lines for this - or do you know of a sneaky way to achieve a workable solution?
Want to reply to this thread?Login with Perch