Best Of
Re: Add multiple Hyperlinks in one cell
Make sure you are using the HTML table card. In your beast mode, you can use one CONCAT function and have as many links as you want. Example:
CONCAT('<a href=https://www.google.com>Google</a>',' ','<a href=https://www.yahoo.com>Yahoo</a>')
Re: Combining Multiple Flags Using Concat() and case stmt
Hi Larry,
It will work when the conditions are met, when they are not it will be completely null.
The solution here is to account for when the holds do not = 'Y' by adding ELSE to your case statement:
CONCAT(
CASE WHEN New Logo Hold = 'Y' THEN 'New Logo Hold' ELSE '' END,
CASE WHEN My Product Customization Hold = 'Y' THEN ', My Product Customization Hold' ELSE '' END
)
This is working for me and I believe giving the results you are looking for.
Re: Combining Multiple Flags Using Concat() and case stmt
As @colemenwilson said, most Beast Mode functions will return NULL if any of the parts being evaluated return null, this is why having the ELSE statement to return an empty string instead works. If you're not using case statements but something else as part of the values to concatenate, you should enclose those in IFNULL() statements. Just remember that after you've concatenated all the possible flags as strings, you might end up having the end being ', ' in which case just for ease of view, you might want to remove this where applicable.
Intro
Hello everyone. I work for a company head quarterd in St. George, UT called Vasion. I have been a Domo user for several years but just recently joined the community. I would like to use the community to up level my Domo game. Thanks in advance for any great ideas I pick up from being a member.
scsincla
Re: Pivot Table Order of Columns
@marcel_luthi You're right, it does seem like there should be a setting for that. It sounds like a good candidate for the ideas exchange.
