I'm currently trying to achieve something where I can click on an item in a column, like a name for example. I want it to either re-render the table to another table, or send me to a new site with another table, containing data from a different query.
What I can't seem to figure out is how to achieve this. I don't think I can achieve the "URL||column_name" inline in the query (as by the pre-filtering by url requirement), and it doesn't seem to work when I set the column prefix as the URL (it just renders the prefix and the received data). I think I might be missing something but I'm a bit stuck so any advice would be really appreciated :)
Thank you for your response. Does this not involve the wpDataTables URL link columns format? I was trying to use that and use the prefix to insert the url we wanted before the "||". This does make sense though and I will try this solution you've helped me with, thanks again :)
I'm currently trying to achieve something where I can click on an item in a column, like a name for example. I want it to either re-render the table to another table, or send me to a new site with another table, containing data from a different query.
What I can't seem to figure out is how to achieve this. I don't think I can achieve the "URL||column_name" inline in the query (as by the pre-filtering by url requirement), and it doesn't seem to work when I set the column prefix as the URL (it just renders the prefix and the received data). I think I might be missing something but I'm a bit stuck so any advice would be really appreciated :)
Hello Daniel
Thank you for your purchase.
So, if I understood correctly, you would already have another table created, and displayed on another page, right?
If that is true, you can use the CONCAT function in an SQL query.
You can pull the data like this:
SELECT column1, CONCAT('<a href="url-to-the-site.com/', `yourtable.nameColumn`, '/">', `yourtable.nameColumn`, '</a>') AS clickableColumn FROM yourtableThen, the second column would be generated as:
And it would be a customName hyperlink.
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
Thank you for your response. Does this not involve the wpDataTables URL link columns format? I was trying to use that and use the prefix to insert the url we wanted before the "||". This does make sense though and I will try this solution you've helped me with, thanks again :)
Hi Daniel
Aleksandar is assign on our other products this week, so I will help you out.
Solution that Aleksandar provide to you will generate link in the column as the same as you manually insert https://google.com || Google in cell.
My suggestion is to try Aleksandar solution and if you have any other question please feel free to ask.
Best regards.
Kind Regards,
Isidora Markovic
wpDataTables: FAQ | Facebook | Twitter | Front-end and back-end demo | Docs
Amelia: FAQ | Facebook | Twitter | Amelia demo sites | Docs
You can try our wpDataTables add-ons before purchase on these sandbox sites:
Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables