We're Moving to a New Support Platform – Starting June 1st!
We’re excited to let you know that starting June 1st, we’ll be transitioning to a new support system that will be available directly on our product websites – Amelia, wpDataTables, and Report Builder. In fact, the new support platform is already live for Amelia and wpDataTables, and we encourage you to reach out to us there.
You'll always be able to reach us through a widget in the bottom right corner of each website, where you can ask questions, report issues, or simply get assistance.
While we still do not offer live support, a new advanced, AI-powered assistant, trained on our documentation, use cases, and real conversations with our team, is there to help with basic to intermediate questions in no time.
We're doing our best to make this transition smooth and hassle-free. After June 1st, this current support website will redirect you to the new "Contact Us" pages on our product sites.
Thanks for your continued support and trust – we’re excited to bring you an even better support experience!
I created a table using SQL.
Code:
SELECT id AS UserID FROM wp_users
Execution result:
UserID
1
2
3
4
...
I want to use this to create a link to the user page.
ProfilePage
mydomain/wp-admin/user-edit.php?user_id=1
mydomain/wp-admin/user-edit.php?user_id=2
mydomain/wp-admin/user-edit.php?user_id=3
mydomain/wp-admin/user-edit.php?user_id=4
...
Is there a way to achieve this?
Hi Kohei
Thank you for reaching out to us.
If I understand correctly you want an entry from the table as a hyperlink that would take the visitor to the specific post or page? That link would be dynamically generated by the content of the cell, right?
If that's true, you could use the CONCAT function, like this:
SELECT column1,column2, CONCAT('<a href="www.yourwebsite.com/page1/',yourTable.column3,'">',yourtable.column3,'</a>') AS HyperlinkFROM yourTableThis will create a hyperlink to www.yourwebsite.com/page1/value1 if there's "value1" entered as cell data in column3. On another row, it could be www.yourwebsite.com/page1/value2 if there's "value2" in the cell, and so on. So, this would be a hyperlink which could be shown in the modal, and it would take the user to the respective page.
I hope this helps, do let us know if you need any further assistance.
Hi Blaženka,
Thank you! It certainly did what I wanted it to do with this code.
One more question, how can I open the hyperlink created in this way in Modal? You said "this would be a hyperlink which could be shown in the modal", but these hyperlink are normal link.
I would like to open the link in modal if possible.
Hi Kohei
Please have a look at our Master Detail addon which you can use to display information in this way
https://wpdatatables.com/documentation/addons/master-detail-tables/
Do let us know if you need any further assistance.
Hi Blaženka,
I understand that the MD add-on popup is for a horizontal table with many columns (e.g. 50 columns), and if the first 5 columns are displayed, clicking on a row will show the information contained in the remaining 45 columns.
Is my understanding of the above wrong?
If I use the MD add-on, am I correct in assuming that the table containing the URL (link) will open the link as a popup (like an iframe) when I click on the link?
Hi Kohei
You can choose what information you want to display in the MD modal, so it doesn't have to be just additional information from other columns, you can choose to display only this link on a row click but if will still be displayed as a link you won't be able to display the content of the link in the modal I'm afraid.
Hi Blaženka,
Thank you! I'll look MD option.
Please close this ticket.
You are most welcome
If there is anything else we can assist you with please don't hesitate to open a new ticket.
Have a wonderful day!