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.

I know it is deprecated, but it works and I would like to make use of it. 

So I have something like: 

<a href="!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="!init.jspa?pid=10420&issuetype=4&&summary="A1&"&reporter="&B4&></a>

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Apr 22, 2018 in Jira Software

How-to setup a secured Jira Software 7.9.0 on Ubuntu 16.04.4 in less than 30 minutes

...PermissionsStartOnly=true User=www-data Group=www-data ExecStart=/opt/jira/bin/ ExecStop=/opt/jira/bin/ TimeoutStartSec=120 TimeoutStopSec=600 PrivateTmp=true [Install] WantedBy...

1,740 views 14 13
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