Table of Contents
This is a way to automatize the creation, storage and display of the burndown chart of a project using agile methodology
THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND
If you dont have all of this prerequisites or dont follow the instructions this program WILL NOT WORK
- Trello token and key: trello.com/app-key
- Trello board with at least one list with the name "DONE [sprint_number]", where [sprint_number] is the number of the sprint currently doing
- Trello board with at least one list with the name "TODO [sprint_number]"
- Trello board with at least one list with the name "DOING [sprint_number]"
- Trello card on the "DOING [sprint_number]" named "Burndown"
- Create a copy of this Google Spreadsheet [IMPORTANT]
- The script on this repo :^)
- Click Archive > Create a copy; on this spreadsheet
- Update the spreadsheet with your data on the "config" sheet (on the down left side of the screen)
- boardId (Example: https://trello.com/b/tAxyjTco/a3; grab the tAxyjTco part)
- key (Get it here trello.com/app-key)
- token (Get it here too trello.com/app-key)
- sprint_actual (Example: 1)
- Go to Extensions > Apps Script
- Paste the script on the website it was just oppened
- Go to "Triggers" on the left pannel, and create a new trigger with this settings:
- Function to execute: DoAll
- Source of event: Time based
- Select the type of trigger based on time: Daily timer
- Hour selected: 23:00 to 00:00
- Your burndown chart will be added to your burndown card on DOING list every day at 23:00
Distributed under the MPL-2.0 License. See LICENSE for more information.
If you have any issue HERE with the program not working, open an issue with your problem.
alfman99 - @Krowzar - [email protected]
Project Link: https://github.com/alfman99/trello-agile-autoburndown