How to add clickable hyperlink to scheduled report when URL is coming from a column in dataset?

hi! i'm trying to add a clickable URL link to my scheduled reports, but it only seems to be clickable in Domo and is not working through the scheduled reports. I'm thinking the issue might be related to the fact that my URL is coming in as a column in the dataset. this is the SQL I have right now:

CONCAT('<a href="',Article Link,'"','"target="_blank">',Article,'')

Where Article Link is the name of the column with the URL, and Article is the title of the article. I've read on another community post that I should use more CONCAT arguments to get it to be clickable in the scheduled report. Any ideas? Thanks!!

Best Answer

  • trafalger
    trafalger Coach
    Answer ✓

    I don't believe that in scheduled reports that's possible, as like you said, clicking in scheduled reports brings you to Domo.

    You could send a card with a dataset and include a URL field in your data.

Answers

  • trafalger
    trafalger Coach
    Answer ✓

    I don't believe that in scheduled reports that's possible, as like you said, clicking in scheduled reports brings you to Domo.

    You could send a card with a dataset and include a URL field in your data.