nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Creating Issues via direct HTML links dynamically built in Excel

John Funk

I want to dynamically build a URL in MS Excel so when the user clicks the link it auto populates the Create Issue dialog screen. But I need the URL build with multiple dynamic fields. I found this and it works if just one of the fields is dynamic but I can't figure out how to get a second value.

https://confluence.atlassian.com/jirakb/creating-issues-via-direct-html-links-159474.html

I know it is deprecated, but it works and I would like to make use of it.

So I have something like:

<a href="http://jira.atlassian.com/secure/CreateIssueDetails!init.jspa?pid=10420&issuetype=4&reporter="&B8>here</a><br><br>Where B8 is a cell in Excel. It properly populates the value in the URL from cell B8. But I also want to include &summary="&A1 where A1 is another dynamic cell in Excel

But that last part does work. Any ideas?

Accepted answers

John Funk

Figured it out and have it working if you are interested. Looks like this:

<a href=<span>"http://jira.atlassian.com/secure/CreateIssueDetails!init.jspa?pid=10420&issuetype=4&&summary="A1&"&reporter="</span>&B4&></a>

All comments

John Funk

Figured it out and have it working if you are interested. Looks like this:

<a href=<span>"http://jira.atlassian.com/secure/CreateIssueDetails!init.jspa?pid=10420&issuetype=4&&summary="A1&"&reporter="</span>&B4&></a>

Debasish Padhi

Hi John,
Can you please suggest how to build a URL out of excel template?

Thanks,

John Funk

Hi Debasish - Welcome to the Atlassian Community!

Not sure what your question is - the code for the URL is in my answer above. Also, it's always better to create a new question so more people will see it and can respond.