Conditional link in the text reporting tools?
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Is there a way to make the text reporting tool conditional?
What I have is a field which for some records contains a url and for others this is blank. In the text reporting tool I have it currently configured as follows:
However, when I export this to Excel, where there is no link the url is just 'http://' and will error when someone clicks on it. And instead I want it to be blank.
I thought about writing a conditional formula after the text reporting tool
However, as you can see it convert the output into html, which is then just treated as a string in Excel, instead of a hyperlink:
So any suggestions on how to solve this would be greatly appreciated.
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
Solved! Go to Solution.
- Labels:
- Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @cgoodman3
I would usually solve the issue in this way.
Workflow:
Splitting with data and no data into separate streams using report text tool as needed and merge it back.
If you provide more background on the usecase we can help you better.
Hope this helps : )
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @cgoodman3,
Could you create a conditional field to set a predefined link value?
IF [Deeplink] = null() THEN '' ELSE 'Link' ENDIF
and use the field as your link text?
Kind regards,
Jonathan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
As @Jonathan-Sherman pointed out it's just a case of doing the conditional statement before the tool instead of after it.
Thanks @atcodedog05 for another way.
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
_
