Need help to create a Formula column with hyperlink joining field reference

[pritchsc]

Hi all, 

Just gettig into using the formula colum in JIRA strucure and trying to generate a a reference hyperlink using the content of a custom field. 

Custom field has 12345 as a string. 

Base url is http://domain.application.com/item/

Trying create a reference link that acheives the following colum 12345 which is a link to Base url + Custom field. 

I have followed the atlassian wiki markup format "[string|url]" but the format is incorrect and returns ??? 

Any pointers would be much appreciated.  

[David Niro _Tempo_ · Accepted solution]

Hi @pritchsc ,

David from ALM Works here.  Just wanted to follow up here with my response to the other post.

For your scenario, we could use something like: 

concat(URL;appID)

If there's no appID in a field, the formula will just return the base URL.  To avoid this, you could incorporate an IF statement like this:

IF(appID,concat(URL;appID))

In this way, it will only show a value if there is an appID present.

Please give them a try and let me know if it helps!

Best Regards,
David Niro
www.almworks.com

[pritchsc]

Hi David,

Thanks for the information - much appreicated. Almost there with the config. 

I now see the url correctly displayed, but would like to make the url hyperlink have a the appID as the reference that is displayed, which when clicked would direct the user to the url issue. 

I read that this could be acheived using some notation like [Atlassian|http://atlassian.com], but have not managed to make this work using a reference to a custom field. Is that possible? 

Was thinking this might look like: 

IF(appID,[concat("appID:"; appID)|concat("https://application.domain.com/#/items/";appID))

Thanks, Scott. 

[David Niro _Tempo_]

Hello Scott,

You are very welcome!  

Please let me know if the formula below works for you.  

IF(appid,concat("[";appid;"|";"baseurl";appid;"]"))

I look forward to your feedback!

Best Regards,
David Niro
www.almworks.com

[pritchsc]

Hi David, 

Worked perfectly! Thanks for your support and sharing your valuable time, although a small deal, it was something that I was sure the product could support.

Great product!

Regards,

Scott.