URL Mapping

StuM

Hi! I have a quick question regarding URL Mapping.

So on a table in a Domo Dataset, I wanted to make cells "clickable" so that when a user clicks on it, it leads to a hyperlink attached to it.

I was able to use this formula in doing so: (where Program guide URL and certifications are other columns of that same table)

CONCAT('<a href="',`Program Guide URL`,'"></a>',Certification,'')

However, in the case where the Program Guide URL has missing values or "Does not exist" filled up instead of an actual URL….it still leaves the text as "clickable", but does not lead to anywhere

Is there any way I can fix this? Thanks!

MichelleH

@StuM To keep the text, just add ELSE `Certification` to your case statement for any rows without a URL

GrantSmith

https://community-forums.domo.com/main/discussion/comment/81043#Comment_81043

CASE WHEN `Program Guide URL` IS NOT NULL AND `Program Guide URL` LIKE 'http%' THEN 
  CONCAT('<a href="',`Program Guide URL`,'">',`Certification`,'</a>')
ELSE
  `Certification`
END

GrantSmith

You need your </a> at the end of certification so that it actually makes the Certification clickable to the URL you define.

CONCAT('<a href="',`Program Guide URL`,'">',`Certification`,'</a>')

StuM

Thank you! Just realized that I mistyped it in the post, but it went properly in Domo.

My main question was regarding values under the Program Guide URL that are either empty or not URL's. Is there a way to make those NOT clickable in those scenarios? (otherwise, if I click cells with non-existing URLs, then it just won't do anything)

Currently it still looks like they are clickable.

MichelleH

@StuM I'd suggest using a case statement to only include the HTML formatting if the Program Guide URL like below:

case 
  when `Program Guide URL` is not null 
    then CONCAT('<a href="',`Program Guide URL`,'">',`Certification`,'</a>') 
  else `Certification`
end  

GrantSmith

CASE WHEN `Program Guide URL` IS NOT NULL AND `Program Guide URL` LIKE 'http%' THEN 
  CONCAT('<a href="',`Program Guide URL`,'">',`Certification`,'</a>')
END

trafalger

I agree with Michelle and Grant - blanking it out with a case statement is absolutely the move here!

StuM

Hello!

Thanks!

These end up with blank rows for values without invalid hyperlinks (looks like empty cells)

Is there a way to keep the text that was originally there but removed the "clickable" part of the text (so its just the plain text, whereas those with hyperlinks would be those text with a clickable hyperlink)

MichelleH

@StuM To keep the text, just add ELSE `Certification` to your case statement for any rows without a URL

GrantSmith

https://community-forums.domo.com/main/discussion/comment/81043#Comment_81043

CASE WHEN `Program Guide URL` IS NOT NULL AND `Program Guide URL` LIKE 'http%' THEN 
  CONCAT('<a href="',`Program Guide URL`,'">',`Certification`,'</a>')
ELSE
  `Certification`
END