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, likes for trees, atlassian community, social impact, tree planting campaign, community kudos, atlassian giving, environmental impact, sustainability, likes for good, atlassian social responsibility, community challenge

Make every click count—help us plant 50,000 trees! 🌳

Want to make your everyday Community actions directly contribute to reforestation? The Atlassian Community can achieve this goal by liking a post, attending an ACE, sending your peers kudos, and so much more!

Help us plant more trees
AUG Leaders

Atlassian Community Events