Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How would you get Google Script to run/update Jira() in Google Sheets?

Edited
Anna Minx I'm New Here Sep 20, 2021

I have a google form that imagine will be edited multiple times. It provides info into a google sheet. I need edits that update data from specific columns to trigger JQL queries based on their input. 

For instance:

A PO submits a form that creates a new row (row N) in a sheet. Column A Row N cell has the Product Name. Column B Row N row cell has the build Version

When an edit comes to the row/sheet I want it to trigger Jira to query the open issues for the product and the version and put the number in a cell in the row (Column C Row N). I imagine that I would use the Google Script onEdit function to trigger the Jira query somehow

From a dashboard this query gets me the info that I want

(issueType = Bug AND statusCategory not in ("DONE")) AND (("Product Area[Dropdown]" = Cell data Product Name AND issuetype = Bug AND "Release[Version Picker (multiple versions)]" = "Cell data Version" ) 

Thanks for considering this. I am very new to JQL and Google Script

0 answers

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Work Management

Lessons from Vilius Zigmantas’ path to Continuous Process Improvement at GeoComply

  “Organizations are made of people who create and follow processes which are constantly changing and are in need to be supported and nurtured… this is the spot where I realized I can br...

702 views 7 15
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you