Create a URL with CONCAT and variable in the middle.
I am trying to have a cell value where it shows VARIABLE
. Everything else is part of a constant URL. I just can't get the variable To be in the middle of the URL. I have worked with others where the variable is on the end and looks like this
CONCAT('<a href="https://www.purchasingplatform.com/admin/products/', `PP Item #`, '" target="_blank">', `PP Item #`, '</a>')
Tagged:
0
Answers
-
I think your issue is around the double quotes in parts. Here is an example of how I did one similar where ClaimNumber is my variable name:
CONCAT('<a href="https://mydomoinstance.domo.com/page/954056803?pfilters=[', '{%22column%22:%22ClaimNumber%22,%22operand%22:%22IN%22,%22values%22:[%22', `ClaimNumber`, '%22]}', ']" target="_blank">', `ClaimNumber`, '</a>')
I found it worked best to break things up into more concat statements than technically necessary to deal with the quotes.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 656 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 813 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 773 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 79 Workflows
- 23 Code Engine
- 38 AI and Machine Learning
- 19 AI Chat
- AI Playground
- 1 AI Projects and Models
- 18 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 143 Manage
- 139 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive