Creating Issues via direct HTML links dynamically built in Excel

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?

1 answer

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>

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Thursday in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

655 views 4 15
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot