Just purchased WPDataTables and really liking it so far. My question:
I would like to link to another website based on the contents of the cell. The cell value is a case id, not an entire hyperlink. Is there a way to edit the hyperlink so that it behaves like the following:
example table cell value = 12345
make the hyperlink value = www.somewebsite.com/case=?12345
Hi,
Just purchased WPDataTables and really liking it so far. My question:
I would like to link to another website based on the contents of the cell. The cell value is a case id, not an entire hyperlink. Is there a way to edit the hyperlink so that it behaves like the following:
example table cell value = 12345
make the hyperlink value = www.somewebsite.com/case=?12345
Hello Travis
Thank you for your purchase, and for your kind words.
You can do this only with SQL Query based tables, using the CONCAT function.
For example, if you have a table in your database, and you want to add a link column which would be dynamic, you can add it like this:
SELECT *, CONCAT('<a href="https://www.somewebsite.com/case=?',case_id,' target="_blank">',case_id,'</a>') AS Link FROM myTableAnd it will create a new column, where the column "case_id" data will be dynamically added to
I also added "target="_blank"" so it opens in a new tab.
I hope this helps.
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