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!

Okay
  Public Ticket #3957341
How to get url from another column
Open

Comments

  • Faraz started the conversation

    Hi,

    I am using a JSON table. The data I'm fetching has URL in one column and the Title in another column. How can I add the URL to the title under an <a href> tag? I have tried to Transform Value and added both column with &"||"& but it also displays the URL column. 

    I basically want something like this:  <a href="{data from url column}">{data from Title column}</a> displayed in one column.

    Thanks

  •  1,895
    Miloš replied

    Hi Faraz,

    This is a common use case for our Transform Value Feature, but there are some important details to look for.

    It seems you might be using one of these columns as an URL link data type?
    If so, please change it to String in order to be used properly for Transform feature.

    - For example, if you use data source such as the Spreadsheets sush as Excel/CSV/Google Sheets and others, have a specific way how they create and render hyperlinks.

    Our Plugin can only render HTML hyperlinks.

    One way you can work around this is to try our Transform Value feature to make custom links.

    You could separate the data for the hyperlink into two columns on your Sheet; or in this case, JSON;

    - One column for the 'URL link itself'

    - And another column to store the 'displayed text' for the hyperlink.

    Then, with our Transform value feature - you can use a String Column in our Table and create a dynamic custom HTML a href tag and inside it you can call these column placeholders.

    ( Optionally you can of course add 'target blank attribute' to open the link in new tab)

    For example, let's say we called the URL column just "URL" and the other Column "displayed text".

    Then, the Transform Value would be something like this :

    <a href="{URL.value}" target="_blank">{displayed text.value}</a>
    

    Then the String Column in which you used this is going to render each row to pull the values from the respective column placeholders.

    You can check out the Documentation Page i sent above to see more detailed examples how you can use the Transform Value feature.

     

    As mentioned, just make sure that each column used in the process is set as String type.

     

    I hope that helps.

    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    Try our FREE mapping plugin! MapSVG - easy Google maps, interactive SVG maps and floor plans, choropleth maps and much more - https://wordpress.org/plugins/mapsvg-lite-interactive-vector-maps/

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia 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

  • Faraz replied

    Thanks. This has solved it for me.