Domo external Link to ADP

Hi ,

I am trying to create a link on associate id (Domo) when clicked on it would take to ADP (https://www.adp.com) and I have used this but it seems to be not working(just adding a link but its not opening up in a new window ) .Please if anyone can help ?

CONCAT('<a href="https://www.adp.com/"','"target="_blank">',EmployeeID,'')

Answers

  • n8isjack
    n8isjack Contributor

    Hi Ajita! I think you are really close. I think you are just missing the ending 'a' tag: </a>

    This example also simplifies the concat:

    CONCAT('<a href="https://www.adp.com/" target="_blank">', EmployeeID, '</a>')

    Good Luck!

    brought to you by Arigato Analytics

    www.arigatoanalytics.com


    **Say "Thanks" by clicking the "heart" in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • Ajita
    Ajita Member

    Thanks for your help but still it is not opening .

  • ST_Superman
    ST_Superman Domo Employee

    Try this?

    CONCAT('<div><a href="https://www.adp.com/" target="_blank">',`EmployeeID`,'</a></div>')

  • Ajita
    Ajita Member

    Still not working

  • n8isjack
    n8isjack Contributor

    Is ADP one of the approved links for you company? You might need to url approved by Domo Support.


    **Say "Thanks" by clicking the "heart" in the post that helped you.
    **Please mark the post that solves your problem by clicking on "Accept as Solution"
  • Quick question, should the link just take you to the main ADP website or a specific page?

    I learned from experience that mixing double and single quotes is often misleading and confusing. The following syntax should work and take you to the ADP homepage on all rows, you might need to update the href to something different if the idea is to take you to different pages based on the row (you should know how the URL will be composed in that case):

    CONCAT('<a href=''https://www.adp.com/'' target=''_blank''>',`EmployeeID`,'</a>')
    

    Please note you can use two apostrophes to escape one and keep this working. This should work for Mega Table cards.

  • Ajita
    Ajita Member

    My apologies for updating you so late, the link should take me to ADP .

    Its still not working .

    1. CONCAT('<a href=''https://www.adp.com/'' target=''_blank''>',`EmployeeID`,'</a>')

  • @Ajita Try adding <div> to the beginning and end of your HTML, and "','" between the URL and target field:

    CONCAT('<div><a href="https://www.adp.com/"','"target="_blank">',`EmployeeID`,'</a></div>')

  • I just tested on my end and seems to be working. What kind of card are you trying to use this in? I've done so in a Megatable with no issues. You need to be in the card view mode not the Analyzer for the link to work.

    When looking at the card and clicking on the link it opens in a new tab as expected. Keep in mind that html tags do not work the same on all Card Types.