Content Manager for Sorting a Large Project List

Hello,
I’ve been doing wix sites at a more basic level for quite some time now. However my new company hit me with something i never had to do before.

My company wants me to create a page that will display 250 projects, and be sortable by project classification. (Finance, Conflict, Monitoring…etc.
The issue is, each project has multiple project classifications. so one project could have 3 project classifications. we don’t want it displayed 3 times, only displayed once when we are viewing all the projects, (ex Project 1 - Finance, Monitoring

However if you sort by project classification (lets say finance for example) it will show up in that sorting, and any other sorting its classified under. (so sorting under finance would show project 1, but sorting under monitoring would also show project 1, etc etc…)

Is there a way to do this with tagging? for example making Finance Code 101 and Monitoring Code 102…etc etc. so then i can tags that aspect and have it displayed? but how would i set up the sorting drop down box for plain text? I need some ideas on how to build this properly. there are about 15-20 classifications.

Hello.

You can do this by following this example: Filter With Multiple Options

It would be even better if you created a separate collection for the tags and use the tags field to build dropdown options like in this example. When creating the main collection you can just use the tags field as a reference field .

Good luck!

Sam,

Thank you for your comment its helpful to know this is possible. is there any way i can get some specific help from you on this?

I’ve built a data collection with the project codes and their corresponding description.

Were thinking about maybe just building a separate database for each project type and just lost them when they are selected from the drop down menu.

regardless, if i have the reference field for project classification set and i tag whatever projects there are in that field. i need to be able to sort by that field. how do i do that in the code?