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?
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>
Hi John,
Can you please suggest how to build a URL out of excel template?
Thanks,
DP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.