Creating Issues via direct HTML links dynamically built in Excel

John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 14, 2017

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

1 accepted

1 vote
Answer accepted
John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
December 18, 2017

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 March 8, 2023

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

Thanks,

DP

John Funk
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
March 8, 2023

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. 

Suggest an answer

Log in or Sign up to answer