Hi, I would like to make a table that includes a column that provides a URL link called 'Details' for each row, which upon clicking would generate a report with information from two other tables that is related to the primary table (based on the primary/foreign keys).
To generate reports, though, you would need to purchase our Report Builder add-on. When you do this, you can create a template for the table which is used to combine the other two tables, and generate a report from it. Then, in main settings of wpDataTables, you would need to enable "Parse shortcodes in strings" slider, so you can add the Report Builder's shortcode in a cell, and when users click on the button, it downloads the report. The column would have to be "string" type, so no need for URL type columns.
Generally speaking - you can create a URL link column and make it look like a button, so users only see "Details" in it, but I don't believe that you would have to use this since you can simply put the Report Builder's shortcode in the cells.
Also, please note:
Images, URL links, e-mail links are currently unsupported (“Raw” cell values will be inserted, but the links/images won’t)
Only a single wpDataTable can be referenced in the report
All source columns should be existing within the same template table, i.e. it’s not possible for the moment to have separate tables in the template for column1, column2, etc.
Please take a look at the Report Builder's documentation (link provided above), and see if it would suit your needs. There are a lot of examples there, so you can see its possibilities.
Hi, I would like to make a table that includes a column that provides a URL link called 'Details' for each row, which upon clicking would generate a report with information from two other tables that is related to the primary table (based on the primary/foreign keys).
Hello Marissa.
Thank you for your purchase.
To generate reports, though, you would need to purchase our Report Builder add-on. When you do this, you can create a template for the table which is used to combine the other two tables, and generate a report from it. Then, in main settings of wpDataTables, you would need to enable "Parse shortcodes in strings" slider, so you can add the Report Builder's shortcode in a cell, and when users click on the button, it downloads the report. The column would have to be "string" type, so no need for URL type columns.
Generally speaking - you can create a URL link column and make it look like a button, so users only see "Details" in it, but I don't believe that you would have to use this since you can simply put the Report Builder's shortcode in the cells.
Also, please note:
Please take a look at the Report Builder's documentation (link provided above), and see if it would suit your needs. There are a lot of examples there, so you can see its possibilities.
Best regards.
Kind Regards,
Aleksandar Vuković
[email protected]
Rate my support
wpDataTables: FAQ | Facebook | Twitter | Instagram | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Instagram | Amelia demo sites | Docs | Discord Community
You can try wpDataTables add-ons before purchasing on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables