Beast mode CONCAT() for creating a dynamic link in a table

PK Member

I have a field in my dataset which I want to use to create a new field which is a URL in the below format - 


<a href="[`DatasetField`]" target="_blank">[`DatasetField`]</a>


Where `DatasetField` is a column in my dataset. 


I am doing CONCAT like on the lines I have mentioned but it does not escape quotes - 


CONCAT('<a href=','\"',"",`DatasetField`, "" target="_blank">",`DatasetField</a>)


I know I am missing something and not doing it right. Any help with this would be really appreciated.





  • guitarhero23
    guitarhero23 Contributor

    Here is one I use for Salesforce where Id is a domo column


    CONCAT('<a href=',`Id`,' target = new> View in Salesforce </a>')



    Try this and if that works then attempt to add the datasetfield to the visible text for the URL

    CONCAT('<a href=',`DatasetField`,' target = new> View this data</a>')


    Is their a reason for the extra ','\"'," before the www.example?

    **Make sure to like any users posts that helped you and accept the ones who solved your issue.**