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>

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?

[John Funk · Accepted solution]

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

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

[Debasish Padhi]

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

Thanks,

DP

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