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