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
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-123to display as the only output in that field
project-123link to an external URL instead of a note named after the URL
Any help on this would be greatly appreciated!