I have a csv with 3 columns (Wattage, Product Number, Lamp Description).
I need it to work similarly to this with an updated CSV:
[login to view URL]
See CSV attached.
Column 1: 'Wattage'
This can be used for the filter but would be hidden
Column 2: 'Product number'
I need this to be turned into a link to download a pdf
12345 would link to ../wp-content/uploads/hid_data_pdf/[login to view URL]
85858 would link to ../wp-content/uploads/hid_data_pdf/[login to view URL]
Colum 3: 'description'
This just stays as text.
Currently the CSV holds 10 products this will most likely need to be divided into separate tables with the product titles above each table.
I have attempted to use Tablepress with a filter extension however I have run into issues as I couldn't find a solution to filter multiple tables at once.
The data needs to be be easy to modify once completed.
If it can work in tablepress great but I am open to other recommendations.
The table needs to be responsive.
Ideally if I can drop the table in using short code.
Please provide me with an idea on how you would tackle the project.