URL Mapping
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!
Best Answers
-
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
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Answers
-
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>')
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
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.
0 -
CASE WHEN `Program Guide URL` IS NOT NULL AND `Program Guide URL` LIKE 'http%' THEN CONCAT('<a href="',`Program Guide URL`,'">',`Certification`,'</a>') END
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
I agree with Michelle and Grant - blanking it out with a case statement is absolutely the move here!
0 -
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)
0 -
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
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive