The result I'm looking for is a table of files. The table would provide a list of file names, descriptions of each file, a link to each file, and any other pertinent info, like when each file was last updated.
Since there will be many files in this table, it needs to be able to be filtered by topic/category. Each file needs to be able to have multiple topics/categories associated with it. It would also help if the table can be sorted and edited.
Please see the attached image for an example (I am a bridge engineer, so all the files pertain to different aspects of bridge design).
With the knowledge I currently have, the best way I can think of setting up the table is this:
- Create an HTML table with all the files listed in the table.
- Each table row would have classes associated with it. The classes would represent the topics/categories that the file belongs to.
- Put a bunch of topic/category checkboxes at the top of the table, with a couple buttons like "Filter" and "Show All".
- If the user would like to find all the files related to "Concrete", they would check off the "Concrete" checkbox, then hit the "Filter" button.
- Then I would use jQuery to hide all the table rows that do not have the classes that match the ones that the user checked off.
Here are the limitations of this method that I would like to overcome:
- All the list items are hard-coded into HTML. I'd prefer to have the items in some sort of array or database, or just some way that I can manage them easier.
- I'd like an easy way to add, edit and remove items, other than going directly into the HTML and editing it.
- I'd like the table to be separated from the actual main page that it will reside on because I'd like to be able to pull the table into other pages of our website that are devoted to a particular topic, and automatically filter the table based on that topic.
Any and all ideas on how to set something like this up would be greatly appreciated!!!