Help with filtering a list based on multiple dropdown selections, please.

English
#1

Hello. I’ve been searching around online and I still can’t seem to find a solution. I was hoping someone here might be able to help. I’m looking to do the following:

  1. When a board game owner is selected from A1, a list of their owned games should be listed alphabetically by the Game Title. Otherwise, no games should be listed.
  2. The games should list not only Game Titles, but Player Number, Recommended Players, and Playtime.
  3. If a genre is selected from the Choose Genre(s) dropdown, the listed games should be filtered to only include games including that genre (as seen in the “Game Collection” sheet). If an additional genre is selected, then only games containing both genres should be listed.
  4. Like the genres, if a mechanic from Choose Mechanic(s) the list of games should be filtered to only include games with those mechanics. This also needs to work along with the genre selection.

Example:

  1. Selecting “Alex’s Board Games” should list all of Alex’s games.
  2. When selecting “Card Games” from a Choose Genre(s) dropdown, the following games should be listed:
    Anatomy Fluxx
    Binding of Isaac: Four Souls - Ultimate Collector’s Edition, The
    Cult Following
    Here to Slay
    Here to Slay: Berserkers & Necromancers
    Here to Slay: Warriors & Druids Expansion
    Unstable Unicorns
    Xybrid
  3. When additionally selecting “Party Game” from another Choose Genre(s) dropdown, only the following should be listed:
    Cult Following
    Unstable Unicorns
  4. Furthermore, when selecting “Storytelling” from the Choose Mechanic(s) dropdown, only the following should be listed:
    Cult Following

If anyone can help me with this it would be highly appreciated. Thanks.

My file:
Board Game Annex.ods (29.1 KB)

#5

I copied your lists of games, genres, mechanics and owners into a database, connected the tables, assuming that each game has one owner, may belong to many genres and may implement many mechanics. Added a filter table and an input form where you can filter by owner, by the pars of from-until values and search titles and descriptions for substrings.
I could not assign the genres and mechanics to your movies because the sheet is too chaotic.
Open the “Filter Form”. The 2 red lists get the genres and mechanics of the selected game.
Lists of genres, mechanics and owners can be edited in their own forms.

ask120294.odb (66.8 KB) [[2nd version] Fixed the small forms. Now you can also assign games to owners, genres and mechanics in the small forms.

#6

I thank you for your effort, but I have specific instructions from my boss to keep the format as a spreadsheet.

As for this, I’m unsure what you mean by it. There are no movies, just games based on movies.

If you think there’s a better way to organize the spreadsheet, I’m open for suggestions.

#7

I meant games, indeed. In the mech form you can assign games to mechanics. In the genres form you can assign games to genres. In the filterable games form you can assign both, genres and mechanics, to games. Just select an item on the left side and pick the associated items on the right.
Each game can have exactly one owner, zero/one/more genres, zero/one/more mechanics.
In 30 years, I’ve never seen any spreadsheet where things like these could be implemented flawlessly and user-friendly.

#2

ever tried Applying AutoFilter ?

Frequently asked questions - Calc - The Document Foundation Wiki - How to use the AutoFilter

#4

First off, this is my first day back to work since I first posted my question, so that’s why it’s taken so long to reply. Now, I appreciate your response, but I’m fully aware of the AutoFilter feature, and this won’t work for what I’m specifically trying to do.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.