Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Creating Issues via direct HTML links dynamically built in Excel

John Funk
Community Champion
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 Champion
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
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
March 8, 2023

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

Thanks,

DP

John Funk
Community Champion
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
TAGS
atlassian, jira product discovery, jpd premium, product management, idea management, product discovery, jira premium, product planning, atlassian community, product development, roadmap planning, product prioritization, feature management

Introducing Jira Product Discovery Premium ✨

Jira Product Discovery Premium is now available! Get more visibility, control, and support to build products at scale.

Learn more
AUG Leaders

Atlassian Community Events