Conditional link in the text reporting tools?

[cgoodman3]

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.

[atcodedog05]

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 : )

[Jonathan-Sherman · Accepted solution]

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

[cgoodman3]

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.

[atcodedog05]

_