Domo external Link to ADP

Ajita · 2023-05-26T15:26:55+00:00

There was an error rendering this rich post.

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,'')

Find more posts tagged with

Accepted answers

All comments

n8isjack

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

Ajita

Thanks for your help but still it is not opening .

ST_Superman

Try this?

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

Ajita

Still not working

n8isjack

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

marcel_luthi

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

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

Its still not working .

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

MichelleH

@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>')

marcel_luthi

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.