Reports - if then for hyperlink

Glenn_Thorne · 12-02-2019 05:12 PM

Hi All

I have a text column called [district]. I need to employ the logic to insert an embedded link in a report that will go to website A.com for district 1 and website B.com if district is 2.

Can this be done? I tried the URL type for the column but that only puts the URL text in the document…

Phil

I believe that you can do this with a template IF expression as described in this article https://help.appsheet.com/en/articles/2697069-template-if-expressions

Glenn_Thorne

Hi Phil,

I understand the if() but the problem is that the resultant text from an if() will be a text OR maybe a http string but not a clickable link like click here that the recipient can click to go to one website or another as decided by the if()

May be no easy solution to this. anyone??

Billy_Sheng

Hi Glenn,

Depending on how many different districts you have, you could turn it into an ENUMList and have it display different links depending on what district is chosen. What type of app are you trying to build?

If you would like, you can book some time with me here: https://app.hubspot.com/meetings/billy42

Phil

Have you tried the HYPERLINK function?
Something like:

<<If:[district] = “district1”>>
<<HYPERLINK("http://www.google.com", "Google")>>
<<EndIf>>

<<If:[district] = “district2”>>
<<HYPERLINK("http://www.apple.com", "Apple")>>
<<EndIf>>

Glenn_Thorne

This looks promising. I found a clumsy workaround but this would be much better. thx.