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.


Last update: December 12, 2023