I’m trying to generate a table that will include links to Jira projects, but I don’t need the entire Jira link displayed in the table. One idea I had was to use split
to pull the Jira issue number from the URL and display that, so the column would be something like
link(jira, <problemcode>) AS "Jira"
Right now, I have
split(jira, "/")
Which parses the links out into separate strings, where project-123
is the 5th field in the list.
The other issue is that link()
appears to only link internally, meaning if I click on it, I just create a note with the name of the URL from jira
. This should instead link directly to my Jira issue.
The two things I need to do from here are:
- Get the
project-123
to display as the only output in that field - Have
project-123
link to an external URL instead of a note named after the URL
Any help on this would be greatly appreciated!