Issues Overview Tool¶
This tool consists of a Google Sheets file, and accompanying Google Scripts. The sheets involved are:
- Issues overview
- Milestones
Purpose¶
This tool is meant to give an overview of all issues in the current sprint. It finds the issues by looking for a specific milestone, and it includes both open and closed issues.
Setup¶
The tool needs to be setup with data about the current GIRAF team in order to function.
The data is entered into some of the sheets, and the Google Scripts found at Tools>Script Editor in the menus bar.
The Milestones sheet must contain any milestones used for issues by the GIRAF team on GitHub. These milestones are meant to represent the individual sprints.
In the API.gs file found with the script editor, the SEMESTER_START_DATE needs to be updated to the start date of
the current GIRAF teams semester.
In the same file, the ACCESS_TOKEN needs to be updated with a GitHub access token from one of the team members.
An access token can be generated here.
Usage¶
The tool is used with the Issues overview sheet.
First, the milestone must be set with the dropdown.
Then the sheet is updated with information about the isuses by pressing the Update button.
This button has the getIssuesOverview script assigned, which can be found in the IssuesOverview.gs file.
