... 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 posted last year about backing up the Trello Boards that we were using for our Scrum backlogs. There's been a fair amount of interest in the post, and some requests for the data to not be displayed in such as Scrum-centric manor...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 therefore hatched a plan to use the current date and time as the first 12 digits of an EAN13 barcode, and then automatically calculate the check digit to put on the end, and this is the result...Read More
... I've been using Rational to edit CLLE and RPGLE source for some years now, but if I wanted to quickly view a specific source member I would often fall back to a Client Access session, and use one of our custom commands, DS (Display Source) to quickly display the member in SEU. Our DS command determines the source library, file, and member used to create an object, and then opens it, so it's a really fast way to view the source for any object. That being said, viewing source in Rational is so much better than using SEU, so I wanted to find a quick way of opening a member that I was interested in...Read More
...I stumbled upon this great article which shows how to use the geofence feature in Find My Friends to control a home heater. I had no idea it had the ability to send an email to any address when you arrive or leave a location, but it was exactly what I needed to trigger my automated security system...Read More
...with this initial script working, it now allows my Mac mini to switch on the receiver, select itself as the source, and play any audio I want when a particular event occurs, and that opens up all sorts of automation possibilities for the future....Read More
... 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
... I yearned for an easy way to easily access the list of available procedures from within Rational itself. After a bit of Googling, and some rummaging around in the file system I came up with a simple and elegant solution...Read More
...whether it's because I've experienced a natural disaster or because I spent some of my formative years in the Boy Scouts I'm not sure, but events half a world away this week have re-enforced the notion that it's good to "be prepared"...Read More
...This is not a headline you're likely to find in your RSS feed any time soon, but what if one day is came true? Would iOS users worldwide swap their hard earned cash for an app that aimed to improve their dental health?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