Last Friday there was a lot of debate in our office. Not about the new construction we are undergoing as our U.S. teams expands, but about the big game to be played on Sunday. Our local sports franchise had made it to another big game and everyone had their plans. Some were hosting parties at their houses. Others were going to local establishments for drinks and good times. Others like me were going to bunker down and remove themselves from outside world contact until there were zeros on the game clock.
One of my colleagues began telling me about the great “squares” he got in his wife’s office pool and demanded an explanation as to why we weren’t doing one. A few guys popped their heads up and said they would be willing to participate if someone was willing to put a grid together to fill out. I decided that I would take this on but needed to figure out the best way of going about it.
It’s easy, just an 11 x 11 grid in an Excel file or drawn with a ruler, pen, and paper right? No way! If I’m going to spend 10-15 minutes setting this all up why not spend another 25 building an app to do this same thing? This was going to be easier than the app that saved Christmas, all I needed was one entity called “Square” with the attributes “Name”, ”Editable”, and “Number”.
As you can see there’s a little lightning bolt, telling you that I added a microflow on the change of a square. Basically what this did is if the Name was empty then it left it as editable = true, otherwise editable = false. This allowed me to prevent my co-workers from editing other people’s picks.
Then I created a template grid that was 11 x 11, and a couple of microflows. First flow created 121 squares, labeled the header squares, and rendered them un-editable.

The next one used our random number generator from the app store to fill in the values for all of the header rows.

So I launched the app to the cloud and sent out the URL to the office. Everyone selected their squares throughout the day and at days end we got our numbers.

At the end of the day it was really cool to see how quickly this app could be built. Sure I could have put this all on a piece of paper and walked around to everyone. Or I could have put it to a spreadsheet and only let one person edit it at a time. I believe people found it fun to watch the spots being taken while they themselves decided which random square their initials should be placed in.
Obviously there was a great deal more that I could have added to make this a production type application. You know like if we were doing it for money I could have tracked who did and didn’t pay. But gambling is illegal so this was merely for “entertainment purposes only”. It would have been nice to figure out a way to help the local team to victory but unfortunately that wasn’t in the cards.
So when the next Superbowl, U.S. open, Olympics, Rumble in the Jungle, Thrilla from Manilla, Soccer Worldcup, Wimbledon or NBA playoffs are on you know where to go to build your own pool: Mendix! You can try to build a simple app yourself for free here.
Edit: our CEO (who is Dutch) won the pool, probably a good career move to solve business problems and not work in the NFL.