Okay
  Public Ticket #2880597
Problem creating dynamic link
Closed

Comments

  • Gonzaga Rojas started the conversation

    Hi - I have this DB Table on my website at:

    http://sfvranking.elgalactico.gg/

    and I am trying to replicate it using wpdatatables here: 

    https://elgalactico.gg/sfvranking/

    Your plugin seems very powerful and might save me time along the way, however on my new table I can't make the Profile names clickable so that they take me to a different page with filtered data and graphs. How can I accomplish this? (Look at attachments)

    Unfortunately already searched your website for documentation and videos but didn't find what I need. Thanks in advance

    Some useful sources: 

    https://wpdatatables.com/documentation/column-features/url-link-columns/

    https://wpdatatables.com/documentation/table-features/using-placeholders/


  • [deleted] replied

    Hi Gonzaga

    Thank you for reaching out to us.

    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 yourTable 

    This 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.


  • Gonzaga Rojas replied

    Hello @Blaženka, I'll try that today. Thanks!

  • [deleted] replied

    You are most welcomesmile.png

    If there is anything else we can assist you with please don't hesitate to open a new ticket.

    Have a wonderful day!