Reports - if then for hyperlink

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โ€ฆ

0 5 419
5 REPLIES 5

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

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??

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

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

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

Top Labels in this Space