Set the dates in the date pickers and quickly access the spreadsheet with issues.
Choose what columns to show on the issue spreadsheet.
Edit the text fields and pick users as assignees or reporters.
Change issue types, priorities, and statuses for issues. Pick the required option in the single select fields.
The existing way of editing Jira issues is convenient, but not fast enough. We decided to move the Excel approach to Jira Cloud, so that users can view and edit all the required issues on the single spreadsheet without the constant switching between the list and issue details. This way users can keep the context of the whole project, version or sprint and edit all the necessary issue attributes at once.
What it does
The Spreadsheet Issue Editor shows the list of issues matching the specified JQL query and provides a way for their inline editing. You can quickly change columns and apply the required values to fields.
How we built it
Challenges we ran into
The main challenge for us was to recognize custom field types and treat them accordingly. As of now the challenge for us is to support multiple instances of the same custom field in next-gen projects and to add support for text areas.
Accomplishments that we're proud of
We managed to integrate the app with the issue editing mechanism, so that our users can edit all issues inline on a single spreadsheet. The app supports all the essential field types, so our users can save quite enough time on other project activities.
What we learned
We learned that inline editing of Jira Issues is not so easy as we expected with a plenty of peculiarities in each field type.
What's next for Spreadsheet Issue Editor for Jira Cloud
We want to add support for the following:
- text area fields
- multi-select fields
- saving of issue views with custom fields on them