I am creating a portfolio of video production work. I have successfully created a database called "Portfolio," and set up category pages sorted by the type of video production (animation, live shoot, etc.) as well as dynamic pages for each individual video in the database.
However, one of the columns in my portfolio database is "Client" and I wish to be able to create dynamic client pages whereby videos for only that client are displayed. For example, on this page, I would like to be able to click the company's logo:
...to view their "company" page:
At first I tried to add a new category page like this: /Portfolio/Company I get an error message that it is conflicting with the already existing category pages, which have the format: /Portfolio/Videotype. Is there a way around that?
Not knowing if there was, I have created another database called "Clients" and set up the dynamic page above (https://www.richter10point2.com/Clients/Cubcrafters). This will work ok - but I don't know how to filter the gallery on this page dynamically, depending on which client the page is for. Specifically in this case, when I click onto the "CubCrafters" client page, the gallery present only shows CubCrafters videos from my Portfolio database.
I think I should be able to use the .setfilter function on the gallery to filter the items by the company name in my Portfolio database, but I don't know how to do it.
I hope all of that made sense...I am a beginner and perhaps there is a much easier way to achieve what I'm describing. Thanks in advance for your help!