...This worked well until the team decided that they wanted to try using Jira - it worked well for them, but not for me as I had a good setup with the spreadsheet which gave me the exact information I needed, and had the burndown chart working exactly as I wanted - it took into account variations of hours available during the sprint (Some days were meeting heavy for example), which made it much more useful for checking the team's progress, and seeing if corrective action was required...Read More
...you can give read-only access to your Jira projects to the whole world (without requiring a login), but you might run into problems if your competitors got hold of the url, so that didn't seem like a great solution.
I therefore decided to use the Jira Rest API to import the backlog into a Google Spreadsheet, which could then be shared with just our organisation...Read More
... a month ago I released a Google Apps Script that allowed you to Pimp your Trello cards by automatically adding checklists, descriptions and Google Docs (based on a template card), and assigning cost estimates to cards. I received some excellent feedback on what would improve the script and am pleased to announce that Pimp your Trello 2.0 is now available...Read More
...so how do you go about updating a Google Apps Script that you’ve copied? Well it depends on the situation, but basically you have 2 options: kill your copy and start again with the new version, or update your existing script....Read More
...I therefore turned to Google Apps Script, and the Trello API to come up with the Pimp Your Trello Cards spreadsheet which has the following features:
- Runs immediately (Using Webhooks) to pimp any new cards added to a board.
- Runs hourly to re-pimp all cards on the board, in case any webhooks failed, or if the pimping requirements have changed.
- The pimping of a card involves:
- Adding a "cost" to a card title based on the story points on the card (If you're using Scrum For Trello) - This also happens immediately if you change the card description.
- Creating (in specified folders) and then attaching multiple Google Docs.
- Adding a description (based on a template card) if it's missing (e.g. "As a I want to so that").
- Adding any missing (based on name) checklists that appear on a template card.
- Adding missing checklist items that appear on an identically named checklist on a template card.
- Removing identical checklist items that are "checked" on the template card.
... I was recently watching a colleague trying to recreate a bug that involved filling out a 20 field form, and after his 3rd effort, I thought "Wouldn't it be awesome if there was a quick way of pre-populating the form to speed up testing?"...Read More
...Assuming that there were probably other people who would like to snooze (Desktop Gmailers or members of the tinfoil-hat-wearing-brigade not wanting to hand over control of their email to a 3rd party) , I hacked together Gmail Snooze v1.0. My aim was to make it as simple to implement and use as possible: I did consider publishing it as a web app, but I felt it was important that the script be visible so that people could see what was happening to their Gmail....Read More
... I recently did some work for a client who wanted some reports that outlined changes to their Trello boards week to week, and whilst I can't share the resulting code, I thought it would be useful to share how I approached the problem...Read More
But what if you already have an existing backlog, and don't want to spend time re-keying the entries? Well luckily, like most things in 2012, there's an App for that.
Before you get too excited, I should mention that "The App" in this case is a Google Spreadsheet, with a Google Apps Script that leverages the Trello API to import the data. It's simple, effective, and in true agile fashion, it does just enough to get the job done without unnecessary bells and whistles.Read More