is it possible to add a constant in front of values in a column by using a beastmode calc?
I have an 'id' column in a dataset these id's are long and ugly. There is a constant URL that I want to be able to put in front of each value and have the column display this URL constant, followed by the id's. So it is as follows:
Constant: https://xxxxxxxxxx.sugarondemand.com/#Calls/
Plus ID: b36c34d8-86e6-11eb-9f27-12dc896541
To get: https://xxxxxxxxx.sugarondemand.com/#Calls/b36c34d8-86e6-11eb-9f27-12dc896541
is it possible to write a beast mode that would accomplish this, and if so, can you have reflect as a hyperlink?
Best Answer
-
Hi @user048760
What you're looking for is the CONCAT function. It allows you to add multiple columns together with constants to create a single value.
If you're looking for just the URL (which you won't be able to click on but would only be displayed)
CONCAT('https://xxxxxxxxxx.sugarondemand.com/#Calls/', `ID`)
Alternatively you can also utilize some HTML code to convert your URL to a clickable URL.
CONCAT('<A HREF="https://xxxxxxxxxx.sugarondemand.com/#Calls/', `ID`, '" target="_blank">', 'Clickable Text Here Or Use a Column Instead', '</A>')
The `target="_blank" ` tells the HTML to open your link in a new window. If you want it to open in the same window then just exclude that section.
The HTML link will only work in the table type card and doesn't work in other cards at this time.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**3
Answers
-
Hi @user048760
What you're looking for is the CONCAT function. It allows you to add multiple columns together with constants to create a single value.
If you're looking for just the URL (which you won't be able to click on but would only be displayed)
CONCAT('https://xxxxxxxxxx.sugarondemand.com/#Calls/', `ID`)
Alternatively you can also utilize some HTML code to convert your URL to a clickable URL.
CONCAT('<A HREF="https://xxxxxxxxxx.sugarondemand.com/#Calls/', `ID`, '" target="_blank">', 'Clickable Text Here Or Use a Column Instead', '</A>')
The `target="_blank" ` tells the HTML to open your link in a new window. If you want it to open in the same window then just exclude that section.
The HTML link will only work in the table type card and doesn't work in other cards at this time.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**3 -
@GrantSmith Worked like a dream. Thank you!
0
Categories
- All Categories
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 278 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.7K Transform
- 89 SQL DataFlows
- 556 Datasets
- 2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 569 Beast Mode
- 11 App Studio
- 27 Variables
- 579 Automate
- 141 Apps
- 414 APIs & Domo Developer
- 23 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 351 Distribute
- 91 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive