Few month ago, I got a call from a consultant for a Shopping Mall in Bhopal. They had upcoming Lucky Draw Contest in their Shopping Mall

They wanted a simple solution. They wanted a way allow buyers to register themselves when they purchase for more than Rs 5000. Then they want to generate the Lucky Draw coupons and print them.

Why Print ? Why not Paperless – It was just to align with buyer’s mindset. They want to print the coupon and make buyers to drop it in the Lucky Draw Contest box.

I create a simple solution using combination of Google Forms , Google Sheets.

I used Cell Validation and VLook Up, Row functions to solve few important problem. I also create a QR code so that buyers can register themselves quickly after scanning the QR code.

Of course, this is not a 100% foolproof software. But was a very interesting solution to work on.